Oracle SQL Developer Command Line (SQLcl) 18.3 Release Notes

 

Date: October 2018

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

 

These release notes contain the following:

  1. Version Updates
  2. Before You Start
  3. Known Issues
  4. Support
  5. Feedback
  6. Unsupported SQL*Plus Commands
Version Updates


Bug Fixes: 

  • Bug 26988319 - SET FEEDBACK OFF SUPPRESSES SQL QUERY ERRORS
  • Bug 27099811 - SQLPLUS COMMANDS: FURTHER COMMANDS SHOULD NOT BE PROCESSED AFTER
  • Bug 27772048 - PACKAGE COMPILATION MESSAGE NOT SHOWN WHEN USING SILENT OPTION
  • Bug 27812508 - INVOKE SQLCL BUILD STEP NO LONGER WORKS WITH EXADATA EXPRESS
  • Bug 27819303 - SOME NON-INTERACTIVE HOST COMMANDS REMAIN IN OS SHELL
  • Bug 27889468 - SQLCL DOESN'T ALLOW FOR QUOTED VALUES IN CONNECT STRINGS
  • Bug 27994996 - DESC DOES NOT WORK WHEN SCHEMA HAS A #
  • bug 28026275 - PERFORMANCE TEAM WANT SPOOL TO OPTIONALLY TRUNCATE ON MAX ROWS.
  • Bug 28142988 - STACK DUMP WHEN USING DDL COMMAND ON A SYNONYM
  • Bug 28352261 - ANSICONSOLE COLORING CHECK
  • Bug 28372610 - SET DEFINE OFF SHOULD NOT AFFECT SET ESCAPE ON
  • bug 28377838 - UNEXPECTED BAD BIND VARIABLE RUNNING SCRIPT WITH :NEW.DEPTNO FOR TRIGGER
  • Bug 28550897 - SODA COMMANDS ARE BROKEN IN SQLCL
  • INTERNAL - ADDING JAVA EXTENSION CAPABILITY TO SQLCL
Before You Start

JRE Support
  • SQLcl release 18.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
  • Java versions 9 and 10 are not yet supported.
 
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 18.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.
 
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