Oracle SQL Developer Command Line (SQLcl) 22.3.1 Release Notes

October 2022

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

New Features

  • Introduction of new command framework for more user-friendly commands, help, and examples
    • APEX, Liquibase (LB), DataPump (DP), MigrateAdvisor (MA)
    • Help has has command and parameter syntax highlighting, and includes optional -example|-ex flag for printing examples
    • Additional commands will be migrated over in subsequent SQLcl updates
  • SQLcl update to fully support JDK17
  • Upgrade JDBC Driver to version 21.8.0.0.0
  • Liquibase feature enhanced to include most core flags and commands
  • Upgrade of Liquibase to 4.15
  • Support for SOCKS proxy in SQLcl
  • Support for connections to ADBs with auto creation of Bastions where needed

Bugs Fixed

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

34609764
 INSIGHT FAILS TO BRING UP LIST OF PLSQL PROGRAMS ON A PACKAGE
34609737
 INSIGHT IS BROKEN FOR PUBLIC SYNONYMS AND GETTING COLUMN LISTS
34430175
 INSIGHT FAILING TO BRING UP LIST OF COLUMNS FOR A TABLE, VIA A SYNONYM
34556247
 LIQUIBASE CHANGELOGSYNC NOT WORKING
34486962
 LIQUIBASE GENOBJECT -TYPE JOB... CREATES AN XML FILE WITH ERRORS
34449082
 LIQUIBASE GENSCHEMA COMMAND IN SINGLE SESSION BREAKS XML FILE
34389462
 LIQUIBASE GENSCHEMA -SYNONYMS TO EXTRACT PUBLIC SYNONYMS
33981074
 LIQUIBASE UPDATE FAILS - COULD NOT RELEASE LOCK
33974947
 LIQUIBASE GENSCHEMA FAILS WITH ORA-00001: UNIQUE CONSTRAINT
34561140
 COMPLETION FAILS ON PREFIXED COLUMN NAME
34597206
 FK CONSTRAINT DROPPED AND RECREATED WHEN NO CHANGE ON CONSTRAINTS
34620477
 APEX EXPORT COMMAND TO EXPORT ALL SUPPORTED TYPES - INCLUDES EXPTYPE
34395045
 MODELER DDL EXPORTS ALL TABLE COLUMNS AS NOT NULL INSTEAD OF NULL
34624954
 ALL VERSIONS MATCH FROM ZIP TO 'SHOW VERSION' COMMAND   
34619719
 SHOW DATAPUMP - UPDATED TO NEW COMMAND STRUCTURE
34379593
 ALTER SESSION SET CURRENT SCHEMA FAIL ON CREATE CHANGE LOG TABLE
34314655
 ERROR ATTRIBUTE 'RUNINTRANS' IS NOT ALLOWED
34241608
 INVALID TYPE:ID PAIR: NULL USING -EXPCOMPONENTS TYPE:ID FOR APEX
33990654
 REVISIT, DATABASE LINKS DO NOT GENERATE PASSWORD
34432373
 EXTRA KEYWORDS ADDED TO QUERIES WHEN COPY/PASTING THE CODE IN SQLCL
32633569
 QUERY WITH COLUMN NAME COLUMN_VALUE RETURNED AS 'RESULT SEQUENCE'
34605409
 VULNERABILITIES CVE-2022-21510/CVE-2022-21511 IN SQLCL 22.2.1.201.1451 

 

Before You Start

JRE Support

  • SQLcl release 22.3 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.3 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