The SQL* Family - Exploring SQL*Plus SQL Developer and SQLcl Best Practices for Developers and DBAs

By Ami Aharonovich

Elevator Pitch

This session will explore real life examples and include live demonstrations for using the SQL* family of tools which consist of 3 solutions: The good old SQL*Plus command-line interface, the well-known user friendly SQL Developer GUI and the latest Oracle’s SQLcl Java-based command line interface.

Description

This session will explore best practices for using the SQL* family of tools which includes 3 main utilities: The SQL*Plus command-line interface, the SQL Developer GUI IDE and the latest Oracle’s SQLcl Java-based command line interface. Participants will gain significant knowledge regarding how they can use those three tools in order to both administer and develop either cloud or on-premise databases. This session will also include real life examples and live demonstrations on using some very handy commands and features for all three tools while leveraging and enriching your day-to-day productivity and accomplishing your database development and administration tasks much easier and faster.

Notes

This session was chosen and delivered at various Oracle user group events such as DOAG, ilOUG, Kscope and others.