Skip to Main Content

Write Great SQL Office Hours

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

This month we are celebrating Developers at AskTOM. We welcome Developers of all levels of experience to join us at our FREE Developer Live events coming in August. Just click on the left to register today! If you are brand new to Database Technology, then we also have got you covered. Just click on the right for your comprehensive FREE training program to kick start your Oracle Database Development journey!

Header container

June 18

13:00 UTC   Start Times Around the World

SQLcl
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!

Experts

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. 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.