Oracle SQL Developer Command Line (SQLcl) 22.4 Release Notes

New Features

This release has focused on stability closing over 150 issues in the last quarter, with other new features in development for future releases.

• ARGUMENT command
  • The Argument command in SQLcl allows for default values, prompts, and descriptions of positional parameters to sql scripts. These arguments can be managed using the define command as usual.

  
  Example(s):
  Example: Set argument default.
  
  @test
  sql>REM test.sql
  sql>argument 1 default arg1
  sql>argument 2 default arg2
  sql>>select '&1' , '&2' from dual;
  
  'ARG1'  'ARG2'
  ______  ______
  arg1    arg2
  
  1 row selected. 
  
  
  sql> define
  ...
  DEFINE 1 = "arg1" (CHAR)
  DEFINE 2 = "arg2" (CHAR)  
  
  

• LIQUIBASE Schema for DATABASECHANGELOG
  • ENH 34385737 introduced support for specifying a schema for Liquibase DATABASECHANGELOG TABLE with liquibase-schema-name parameter

Bugs Fixed

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

Before You Start

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

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.

• For all SQLcl queries, please use the SQLcl Forum

SQL*Plus List of Unsupported Commands and Features

Commands

• autoprint
• autorecovery
• cmdsep
• copytypecheck
• describe
• eschar
• flagger
• flush
• fullcolname
• logsource
• loboffset
• markup
• recsep
• recsepchar
• shiftinout
• sqlcase
• sqlprefix
• sqlterminator
• tab
• underline
• xmloptimizationcheck