SQL Developer Command Line
SQLcl 18.2

Exchange  Forum  Download  FacebookTwitterYoutube

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.

SQLcl 18.2 Production



Release Notes - Command-Line Reference - Getting Started Video - FAQ - Forum

Key Features

  • In-Line Editor- edit multi-line statements and scripts interactively at the SQLcl prompt
  • 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