Oracle SQL Developer Command Line (SQLcl) 22.2 Release Notes

June 2022

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

New Features

  • MIGRATEADVISOR (MA) – this new command allows you to use the Cloud Premigration Advisor Tool (CPAT) to perform analysis of databases looking for various objects that might be problematic when migrated to the Oracle Cloud, and in particular Oracle Autonomous Database.
  • AQ - this new command allows you to use the Advanced Queuing feature in the database to create queues and queue tables, enqueue and dequeue messages, and and remove subscribers, manage transactional event queues, and much more.

Bugs Fixed

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

34109454 CONNECT COMMAND IS NOT WORKING
34200800 PROVIDE CTRL-C SUPPORT TO COMMAND HANDLERS
34169576 APEX COMMAND HELP DOESN'T WORK FOR EXPORT
34154143 WHENEVER COMMAND IS NOT WORKING FOR SOME COMPONENTS
34151512 INCORRECT FORMATTING FOR INDEXES AND AND REFERENCES IN INFO
34056508 DOUBLE AMPERSANDS FOR VARIABLES NO LONGER WORKING
33562181 FEEDBACK IS NOT SHOWING EXPECTED NUMBER OF ROWS RETURNS IN SOME CASES
31874070 COLUMN HEADINGS ARE RIGHT ALIGNED FOR ALL DATA TYPES NOT JUST NUMERIC
34100096 ERROR IN ARBORI EXECUTION
34258287 SQLCL CONNECTIONS: CANNOT CREATE CONNECTIONS FILE
34232550 CONNECTION ERROR WHEN INVALID REGION IS USED
34146798 SQLCL ON FINDING NO OR WRONG VERSION OF JAVA GIVES MISLEADING INFORMATION
34087574 ERROR USING THE NEW CTAS COMMAND
33287571 SQLCL SHOULD WARN USER WHEN CONNECTION WAS MADE WITH UNREQUESTED DRIVER
34199764 ERROR WHEN SYNONYM CREATED FOR PACKAGE WITH SAME NAME AS SCHEMA
34150073 LIQUIBASE UPDATE NOT WORKING FOR TRIGGER DATATYPE
34105443 UNIQUE CONSTRAINT EXPORTING SCHEMA GREATER THAN 1045 OBJECTS
34049237 ERROR WHILE EXPORTING SCHEMA WITH TOO MANY GRANTS
34255978 DEPLOYING DATABASE OBJECT WITH LIQUIBASE TO A TARGET DATABASE DEPLOYMENT FAILS
33998732 OPENED SCRIPTS DO NOT UTILIZE THE SYNTAX HIGHLIGHTING FEATURE
34197643 REST EXPORT PRINTS OUT "NULL" AND NO ORDS SERVICE EXPORT APPEARS

 

 

Before You Start

JRE Support

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