Understanding Oracle SQLcl

Oracle SQL Developer Command Line (SQLcl) is a free command line interface for Oracle Database. It allows you to interactively or batch execute SQL and PL/SQL. SQLcl provides in-line editing, statement completion, and command recall for a feature-rich experience, all while also supporting your previously written SQL*Plus scripts.

https://www.oracle.com/database/sqldeveloper/technologies/sqlcl/

Key Features

In-Line Editor

edit multi-line statements and scripts interactively at the SQLcl prompt

Change Management

native Liquibase integration, with automatic changelog generation for your Oracle Database objects

Command History

cycle through your 100 previous scripts/commands

Completion Insight

auto-complete object names or keywords using the tab key

New Commands

CTAS, DLL, Repeat, ALIAS, SCRIPT, FORMAT, and many more!

Client Side Scripting

execute javascript to manipulate query results, build dynamic commands, interact with the session, and much more

SQL*Plus Support

SQL*Plus environment settings, commands, and behaviors

Download

• Downloads
• Latest version update

Install Oracle SQLcl & Connect on Database

sudo java --version

which java

cd /<$FILE_PATH>/sqlcl/bin

./sql <$USER_NAME>/<$PASSWORD>@<$HOST>:<$PORT>/<$SID>

Install Oracle SQLcl with Brew (Homebrew)

brew install --cask sqlcl

https://formulae.brew.sh/cask/sqlcl

Start SQLcl

./sql

./sql /nolog

SQLcl Documentation

• Release Documentation
• Command-Line Reference
• FAQ
• Release Notes