Oracle SQL Developer Command Line (SQLcl) 19.1 Release Notes

 

Date: April 2019

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


New Features:

  • JSON Formatter Enhancements 

  • Bug Fixes: 

    29128067 FORUM: UNRECOGNIZED "LOCK TABLE" SYNTAX
    29474801 FORUM: BRACE MATCHING FAILURE
    29128216 FORUM: CASE SYNTAX
    29133925 FORUM: SYNTAX ERROR ON RETURNING CLAUSE
    29141987 FORUM: DATE KEYWORD MAKES CODE UNPARSEABLE
    29212343 FORUM: CONDITIONAL COMPILATION BUG
    29222142 FORUM: REGRESSION ON HIGHLIGHTING MATCHING PARENTHESIS
    29306340 FORUM: PARSING ERROR IN MEASURES OVER CLAUSEE
    29306883 FORUM: YET ANOTHER PARSER BUG
    29291846 FORUM: OPEN SCRIPT IN A WORKSHHET, MISSING CODE FOLDING
    29266092 FORUM: PARSING ERROR AND WRONG GROUP BY ADVICE
    28377838 UNEXPECTED BAD BIND VARIABLE RUNNING SCRIPT WITH :NEW.DEPTNO FOR TRIGGER
    29003931 SQLCL COMMAND FAILS TO START WITH ERROR JANSI
    29222411 IF CLOB IS MORE THAN 500 CHARACTERS OUTPUT IS INVALID
    29279826 POPULATE NLS CALLED 3 TIMES IN A ROW
    29282680 EXPORT TO HTML, IF SEARCH FILTER IS FILLED AND EMPTIED NO RECORDS ARE RETURNED
    29334457 SQLCL GET NOCLASSDEFFOUNDERROR WHEN TRY TO SETUP SSH TUNNEL
    29337896 ARBORI QUERY RETURNS EXTRA TUPLES
    29393507 ATP:THE SAME NAME SYNONYM SHOULD NOT ADDED
    29493734 COPY JANSI INTO SQLCL FAILS
    29510102 FORMATTER INSERTING UNWANTED SPACES INTO NUMBER LITERALS

     

Before You Start

JRE Support
  • SQLcl release 19.1 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 19.1 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