We’re sorry. We could not find a match for your search.

We suggest you try the following to help find what you’re looking for:

  • Check the spelling of your keyword search.
  • Use synonyms for the keyword you typed, for example, try "application" instead of "software."
  • Start a new search.
Cloud Account Sign in to Cloud
Oracle Account

Oracle SQL Developer Command Line (SQLcl) 22.1.1 Release Notes

May 11, 2022

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

Bugs Fixed

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

34049379
ON STARTUP GET WARNING ABOUT WINDOWS REGISTRY KEY NOT FOUND
34141455
SQLCOMPLETER NO VALIDATION ON POSITION VALUE
34136651
UPGRADE LIQUIBASE 4.9.1
34088656
ISSUES WITH LB HELP GENOBJECT AND UNTAG
34062379
LIQUIBASE INCONSISTENT STATE AFTER PARTIALLY APPLIED CHANGE IN CHANGESET 
34048962
LIQUIBASE HELP NOT WORKING
34040532
LIQUIBASE SPOOL DOES NOT SAVE THE OUTPUT INTO LOG FILE
34037051
ABNORMAL BEHAVIOUR OF UPDATE, ROLLBACKSQL, AND ROLLBACK WITH TRIGGER OBJECT TYPE

 

Before You Start

JRE Support

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