Oracle SQL Developer Command Line (SQLcl) 21.4 Release Notes

December 2021

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

New Features - Bugs Fixed

New Features

  • New Command: datapump (dp) - allows for creating and running data pump export and import jobs, as well as moving dump files to the Oracle Cloud Object Store (OSS)
  •  Oracle Cloud DBTools Connections Support

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

33644643 REMOVE DB FROM SQLCL FOR 21.4.0 RELEASE
33632099 ADD OF ORAPKI AND MKSTORE AS COMMANDS
33605429 SQLCL LIQUIBASE INCONSISTENT STATE AFTER PARTIALLY APPLIED CHANGE IN CHANGESET
33605282 SQLCL IN 21C DATABASE DISTRIBUTION FAILS TO START
33590449 CREATE FUNCTION FAILS TO SEND COMMAND TO ENGINE AFTER /
33521829 Q ESCAPE STRING LITERAL NOT INTERPRETED CORRECTLY WITH ODD QUOTES
33489983 LIQUIBASE UPDATE LOOSES BLANK LINES FOR PLSQL PACKAGES
33460526 PRESSING ENTER IN SQLCL ON SOLARIS HAS NO EFFECT
33455849 UPDATE SQLCL JS SUPPORT MESSAGES TO MAKE SURE USE REQUIRES A JDK
33415471 LIQUIBASE EXPORTING ORDS DOES NOT EXTRACT PRIVILEGES
33404421 LIQUIBASE UPDATE COMMAND IS NOT WORKING
33358544 SQLCL FORMATTERS NEED SOME UPDATES FOR CUSTOMER DEFAULTS
33339375 ANSICONSOLE OUTPUT FORMAT HAS WRONG HEADER ALIGNMENT
33174226 SHOW SCRIPT ENGINES AVAILABLE FROM SCRIPTCOMMAND HELP
33114133 LIQUIBASE GENSHCEMA TO ALLOW OPTION TO FILTER OBJECT NAME BASED ON PATTERNS
33074981 JAVA ERROR WHEN STARTING SQLCL 21.2 ON ARM
32471908 ATTEMPT TO CHANGE EXPIRED PASSWORD IS FAILING
31871948 MAKE SODA LIST COMMAND FAULT-TOLERANT
31699606 OTHER USERS CAN'T VIEW DESCRIBE ON OWNER'S VIEWS (PRIVILEGES AND ROLES)
31531325 REPORT HANGS RUNNING SCRIPT THAT INCLUDES COMMAND COL DB_DET NOPRINT NEW_VALUE DB_DETAILS
22017629 IPV6 SUPPORT FOR SQLCL
21104302 ALLOW TAB-COMPLETION DELETE, DESCRIBE AND INFORMATION

 

Before You Start

JRE Support

  • SQLcl release 21.4 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_262
  • Java versions 9 and 10 are not 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 21.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

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