Skip to Main Content

Write Great SQL Office Hours

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

Header container

June 18, 2019

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 give us feedback and be notified of upcoming sessions!

Ask a Question

Ask The Experts - Right Now!

Do you have a question about SQL you'd like our experts to answer in their next session? Sign in and submit it here.

Please note that we cannot guarantee to answer all questions. We cannot help you with open Service Requests or account/licensing issues.


Your Experts
Chris Saxon
Chris Saxon, Oracle Developer Advocate for SQL    
Chris Saxon is the quizmaster for the Database Design competitions and an Oracle Developer Advocate for SQL. 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. My 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.