No results found

Your search did not match any results.

We suggest you try the following to help find what you’re looking for:

  • Check the spelling of your keyword search.
  • Use synonyms for the keyword you typed, for example, try “application” instead of “software.”
  • Try one of the popular searches shown below.
  • Start a new search.
Trending Questions

Oracle SQL Developer Command Line (SQLcl) 17.3 Release Notes

Date: Sep 29, 2017

Version Updates

SQLcl 17.3 updates include enhancments and bug fixes. Here are a selection of higher priority bugs, customer bugs and issues raised by the community on the OTN Forum since the previous release.

  • Tnsping doesn't work for TNS entries
  • Right align numbers in ansiconsole fails to launch external editor
  • SET COLSEP does not work
  • CTAS has a trailing comma on column list def of new table
  • Print autoprint of sys_refcursor wraps at column 80 or less
  • :NEW is prompted as bind in a trigger

Before You Start
JRE Support

  • SQLcl release 17.3 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 17.3 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.


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.


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



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