Command Line SQL with 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

[synthmania]

very userful!! I am gonna start using SQLCLI going forward

[dtfranca]

how can I know my Oracle database has the ORACLECL installed?

[metaalpha]

if Nashorn will be desupported in future, how will we use Javascript scripting