Oracle SQL Developer Command Line (SQLcl) 4.2 Release Notes

 

Date: March 15, 2017

SQLcl on OTN | Getting Started Video | Downloads | FAQ | Exchange | Forum

 

These release notes contain the following:

  1. New Features
  2. Bug Fixes
  3. Before You Start
  4. Known Issues
  5. Support
  6. Feedback
  7. Unsupported SQL*Plus Commands
New Features

SQLcl introduces the power of SQL Developer in a command-line interface, while also supporting everything you know and use in SQL*Plus.

  • In-Line Editing: simply arrow around your currrent statement or script without needing to invoke an external editor
  • Automatic Formatting: SQL output can be formatted to fit your screen or to CSV, JSON, Delimited, HTML, Insert statements, or XML 
  • New Commands: DDL, CTAS, REPEAT, INFO (an updated version of DESC), and many more. Use the HELP command for a full list.
  • Client-Side Scripting: Use JavaScript in combination with SQL and PL/SQL 
  • SQL History: Records previous 100 executed statements and scripts and can be recalled with up and down arrow keys
  • Tab Completion: Get assitance with object names, keywords, and more with the TAB key
  • Oracle Database Exadata Express Cloud Service support
New for March 2017 Update
  • WHICH command
  • FIND command
  • Added the ability to look down the SQLPATH for a file
  • Move sqlcl cd to after directory is made
Before You Start

JRE Support
  • SQLcl release 4.2 requires Java version 1.8 and above. Go here to download the latest version.
  • If SQLcl cannot find a local JRE, you will be prompted to enter the location path for the JRE. Note that the prompt wants only the folder, not the java.exe.  For example C:\Program Files\Java\jre1.8.0_91
 
Known Issues
  • Invoking SQL Recall for a previous statement which has a line exceeding the width of your display, the in-line editor will be unable to access or edit the line with the overflow. Workaround this issue by resizing your terminal display wide enough to prevent line-wrapping.
 
Platform Support

SQLcl release 4.2 is available for Windows 7,8,10 and Windows Server 2008/2012, Linux or Mac OS X. (See full Certification

 
Installing or Upgrading

All new releases of SQLcl and SQL Developer require a full installation. Download and unzip the file into an empty folder. Ensure the "Use folder names" checkbox is checked when unzipping the file.
 
Support

Production Releases - you are supported by Oracle Support under your current database Support license for SQL Developer production releases. Log SQL Developer bugs and issues using My Oracle Support for the product.

Feedback

There are a number of different forums supporting the features in SQLcl. When using the forums, be sure to use clear subject lines to initiate a thread and try to avoid using old, unrelated threads for a new issue.


SQL*Plus List of Unsupported Commands and Features

Commands 
  •  REPHEADER
  •  REPFOOTER

System Variables and Environment Settings via the SET Command
  • autoprint
  • autorecovery
  • cmdsep
  • copytypecheck
  • describe
  • eschar
  • flagger
  • flush
  • fullcolname
  • logsource
  • loboffset
  • markup
  • recsep
  • recsepchar
  • shiftinout
  • sqlcase
  • sqlprefix
  • sqlterminator
  • tab
  • underline
  • xmloptimizationcheck