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.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