What is Oracle SQLcl?

submited by
Super Jumper
2020-06-20 18:52:05

SQL Developer Command Line (SQLcl) was introduced in 2016 and is a new Command Line Interface (CLI) for working with the Oracle Database.

When compared with SQL*Plus, SQLcl provides a modern way of working on the command line with features such as object completion, inline editing and a history of commands regardless of the operating system. SQLcl also makes it easier to transform a query result set into formats such as CSV, JSON, XML using the SET SQLFORMAT command.

Starting with 12cR2 SQLcl is included in releases of the Oracle Database. It is also available as a separate download from the SQLcl home page on OTN.

The information in this post has been distilled from many of Jeff Smith’s superb blog posts. Jeff is a Product Manager at Oracle and is a super nice guy, both on line and IRL and his generous work in the community is something that I really appreciate.

Leave a Comment