Oracle SQL Developer Command Line (SQLcl) 22.1 Release Notes

April 5, 2022

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

New Features - Bugs Fixed

New Features

  • SQL Performance Checks
  • Data Guard commands for Dataguard Broker

Here is a limited list of some high priority bugs fixed for 22.1

  • 3390293 DIFFERENCE IN "SET DEFINE" BEHAVIOUR BETWEEN SQLCL AND SQL*PLUS
  • 33855128 SQLCL IS NOT GETTING LAUNCHED ON LINUX
  • 33680680 CANNOT SET VARIABLE VALUES ACROSS SCRIPT SESSIONS
  • 33649155 WPTG_TSN: DB: NEED TO KNOW STRING IS NOUN OR VERB FOR ONE WORD STRING
  • 33649103 WPTG_TSN: DB: DON'T USE ALL UPPERCASE STRINGS FOR "COMMAND"
  • 33647767 SP2 ERROR DOES NOT RETURNED IF SET FEEDBACK OFF
  • 33837648 CONN -REST <OCID> RETURNS ERROR: INVALID OPTION
  • 33905646 LIQUIBASE DIFF THROWS ERROR
  • 33671914 "LIQUIBASE GENSCHEMA -SPLIT -SQL" RESULTS IN INCORRECT PARSING
  • 33642372 LIQUIBASE UPDATE MESSES UP WHITESPACE / LINE BREAKS
  • 33641234 SQLCL LIQUIBASE SUPPORT FOR INCLUDE AND EXCLUDE OBJECT PARAMETERS
  • 33629363 SQLCL + LIQUIBASE SHOULD BE ABLE TO PERFORM ROLLBACK INDICATING A TAG
  • 33624993 ROLLBACK NOT WORKING WHEN THERE ARE ROWS IN DATABASECHANGELOG_ACTIONS WITH SQL
  • 33130786 LIQUIBASE IMPORTING APEX APPLICATION FAILS WITH ERROR : CANNOT INSERT NULL
  • 33867123 LOAD COMMAND LOADS BY ORDER INSTEAD OF COLUMN HEADER IN SQLCL
  • 33965243 REPEATED DESC COMMANDS ON PLSQL WILL EVENTUALLY BREAK THE CURRENT SESSION
  • 33691403 CONNECTING TO ADBS VIA JDBC-REST (HTTPS) NOT WORKING IN MOST RECENT SQLCL VERSION

Before You Start

JRE Support

  • SQLcl release 22.1 requires Oracle Java version 11 or 17.
  • 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\jdk-11.0.11

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 22.1 is available for Windows 10 and Windows Server 2008/2012, Linux or Mac OS X. (See full Certification)
  • If using a OCI “Thick” connection type, a 21c Oracle Client will be required


 
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