Skip to Main Content

Write Great SQL Office Hours

Free tips and training every month! Subscribe for reminders and more from Office Hours. FAQ

Header container

June 18

13:00 UTC   Start Times Around the World


SQLcl is the latest command line tool for running scripts on Oracle Database.

In this session Jeff Smith will give you an overview of SQLcl, showing you how to get the best out of this fantastic tool.

Highlights of the session are:

- 08:05 Change the format of query output to CSV, JSON, others delimiters, & more with the set sqlformat option
- 20:00 Not sure which table to query? Hit tab to get a list of matching names
- 20:50 Better describes of table details with the info command
- 22:50 Make your own commands with the alias option
- 27:20 Use the DDL command to generate create scripts for your objects
- 36:30 CTAS to generate create-table-as-select scripts
- 41:50 The REPEAT command to execute a SQL statement many times to give you a lightweight performance monitor

Subscribe to be notified of changes to sessions and give us feedback!

Having trouble watching the video on this page? Open the video in your browser.

Your Experts

Chris Saxon
Chris Saxon, Oracle Developer Advocate for SQL    
Chris Saxon is an Oracle Developer Advocate and quizmaster on Dev Gym. His job is to help you get the best out of the Oracle Database and have fun with SQL! He's also part of the answer team on Ask TOM and creates YouTube videos at The Magic of SQL channel.
That Jeff Smith
That Jeff Smith, Product Manager    
Jeff is a Product Manager for Oracle, working on the SQL Developer team. His true passion lies in helping people maximize their productivity and retain sanity while working with database development and administration tools, such as SQL Developer, ORDS and SQLcl.