Oracle SQLcl 23.2.0.178.1027

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

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

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

Named Connections

The connmgr command manages a collection of connections. It allows you to list, show, test and clone connections. It also allows you to import connections from Oracle SQL Developer.

• connmgr import <sql-developer-connections.xml>
• connmgr list <connection 1> ... <connection n>

• connmgr show <connection-name> USER: hr URL: jdbc:oracle:thin:@//hostname:1521/ORCL

• connmgr connmgr test DB213P Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Production Connection Test Successful

• connmgr clone -ORIGINAL DB213P clone ``` connmgr list ... clone ...

Saved Connections

The Connect command has been further expanded to include functionality to allow a user to save a connection. This has two formats.

• While a user is connecting with the connect command, a -save <connection-name> parameter is supported which allows the user to name the current connection details used as a named connection
• Secondly, an existing connection previously created, can also be saved using connect -save <connection-name>
• Connect or reconnect with that saved connection using connect -name <connection-name>

OCI DB Metrics

The ocidbmetrics command collects metrics from the Oracle Database Dictionary and sends them to the Oracle Cloud Infrastructure (OCI) Metrics service.

The command facilitates setting up a new user with the necessary permissions and initiates the collection of metrics with a 15 second time interval between iterations.

You must have an OCI profile setup to use this feature

• ocidbmetrics setup myuser
• ocidbmetrics collect -compartmentId [compartmentId_ocid] -region [region_ocid]

Issues Fixed in 23.2.0

• PLSQL: SHOW ERRORS PERFORMANCE ISSUES WHEN CONNECTING WITH PECULIAR PASSWORD
• LIQUIBASE: SQLCL 22.3 HAS \ INSTEAD OF / IN CONTROLLER.XML ON WINDOWS AS COMPARED TO LINUX/UNIX.
• LIQUIBASE: COMMENTS ADDED TO CONTROLLER.XML FILE IN SQLCL 23.1
• LIQUIBASE: APEX EXPORT FEEDBACK TO DEPLOYMENT SYSTEM CONVERTS THE NAME TO LOWERCASE
• LIQUIBASE: SQLCL HAS \ INSTEAD OF / IN CONTROLLER.XML ON WINDOWS AS COMPARED TO LINUX/UNIX.
  
• CONNECTIONS: ERROR SHOWN WITH SQLCL WHEN LOGIN.SQL HAS "SHOW CONNECTION"

Restrictions

This section describes the restrictions on use that upgrading has introduced.

When using sqlcl in an ORACLE_HOME, it must be a minimum version of 21c.

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.