Oracle SQLcl 23.1.0.089.0929

Release Notes

Date: April 2023

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

Support

You are supported by Oracle Support under your current Oracle Database Support license.

Log Oracle SQLcl bugs and issues using My Oracle Support. To determine the version of SQLcl run this command:

sql -version

Documentation

Getting Started

Documentation on getting started with SQLcl is provided on the oracle.com web site. Click here, navigate to the documentation section and access the book titled 'Oracle SQLcl getting started'.

Feedback

At Oracle SQLDeveloper SQLcl on oracle.com you will find links to forums and social media channels where you can discuss topics with the SQLcl community around the world and leave feedback for the development team.

In the forums, be sure to use clear subject lines to initiate a thread. Provide a complete and clear description of the issue, including steps to reproduce the issue.

Try to avoid using old, unrelated threads for a new issue.

Requirements

SQLcl requires a minimum JDK of 11.0 to run.
JavaScript support in Java 15 and higher require using GraalVM EE with the Oracle GraalVM JavaScript Runtime Plugin
Liquibase support for APEX requires APEX version 18 and above.

New Features in 23.1.0

Connect command expansion

The Connect command has been expanded to include functionality provides a more discrete way of defining a connection. The traditional connect command

connect username/password@connect_identifier

where the connect_identifier can be an easyconnect string, a tns alias, or a tns description. Easyconnect+ introduced options such as protocol and parameters

This release introduces flags to the command which supplement and simplify the command allowing more varied connections to be defined.

The syntax expands on what was supported before. Details of the command can be seen in the help command

help connect

Liquibase enhancements

New options for generating objects in liquibase and specifically increase the flexibility of the APEX command to allow more granular exports have been added. Specifically, new options on generate APEX objects to further extend options to export APEX objects seamlessly -

liquibase generate apex objects (lb geao)

liquibase  geao -api <app id> (where <app id> represents application to be installed)

You can get help on the new command by doing

liquibase geao help

We also have added some new options to the commands

-fail-on-error | foe [Default:false] {true|false}

-runalways | -ra [Default:true] {true|false}
-split | -sp {true |false}

As well as these command changes, we expanded the detail produced in the generated files as well

Added more detail to apex_install.xml to show if overrides were used
New custom runApexScript option in apex_install.xml, see documentation for more detail

Liquibase update has also been extended with options to control how the application is going to be imported

-override-app-alias | -ovaa.      (Override value to be used for the APEX application alias)

-override-app-id | ovai.          (Override value to be used for the APEX application id)
-override-app-schema              (Override value to be used for the APEX workspace schema)
-override-app-workspace | -ovaw.  (Override value to be used for the APX application workspace)

You can see more details using the help command liquibase update help

Enhancements to APEX command

In previous versions we just had the export command. This has been broken down to provide more control and flexibility to the user. use APEX export help for details

export|ex.                    (Export APEX applications and or workspaces)

export-all-applications|exaa  (Export all applications in a workspace)
export-all-workspaces|exaw.   (Export all workspaces without their applications, structure only)
export-application|exa        (Export all or the parts of an application)
export-components|excom.      (Export specific nents within an application)
export-feedback|exf.          (Export workspace feedback)
export-workspace|exw.         (Export workspace without the applications, structure only)
list|ls                       (Generate a list of available components)
log|lo                        (Reports APEX application usage from APEX_WORKSPACE_LOG_SUMMARY)
version|ve                    (Display version information)

Other improvements

Other features and enhancements are included in the 23.1.0 release and include

Improve load command to support Gzip, zip and gz

Issues Fixed in 23.1.0

35164605    INDEX OUT OF BOUNDS WHEN HIGHLIGHTING IS ON AND RUNNING JUST A COMMENT

35068715    LB GEO ADDS BLANK LINE TO TRIGGER TEXT
35042293    LIQUIBASE -GRANT AND -FILTER OPTION WHEN USED TOGETHER RETURNS ERROR
35041864    LIQUIBASE FAILS TO PROCESS LARGE VIEWS
34936524    "ORA-00001: UNIQUE CONSTRAINT VIOLATED" ERROR FOR LB GENERATE-SCHEMA -SYNONYMS;
35037479    SEARCH/REPLACE TYPE OF SQL*PLUS COMMAND USING SQLCL DOES NOT WORK
34680656    SQLCL 22.3 HAS \ INSTEAD OF / IN CONTROLLER.XML ON WINDOWS AS COMPARED TO LINUX/UNIX.
34671379    ERROR: "PLS-00201: IDENTIFIER 'IDENTIFIER_NAME' MUST BE DECLARED" WHEN USING "LB UPDATE" COMMAND
35029218    LB GENERATE-APEX-OBJECT COMMAND DOES NOT SUPPORT -SPLIT PARAMETER [BUT THIS WORKED IN 22.2]
34671379    ERROR: "PLS-00201: IDENTIFIER 'IDENTIFIER_NAME' MUST BE DECLARED" WHEN USING "LB UPDATE" COMMAND