Oracle SQLcl 25.1 Release Notes

Version 25.1.0.101.2353

April 15, 2025

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

 

New Features

Project Command (CI/CD)

  • Materialized Views are now supported
  • ORDS REST Modules are now supported

Connections

  • Connection folders support
  • Added tab completion support
  • Added delete connection to connmgr command

General

  • JDBC 23.7 update
  • Liquibase 4.30.0 update
  • Added SDK command to install JDBC extensions
  • Create MLE Module bundles and Softwate Bill of Materials (SBOM)
  • SET SQLFORMAT DELIMITED now supports SPACE as a delimiter
  • New aliases for listing local schema objects - in addition to 'tables,' you can now use 'indexes,' 'views', 'functions,' 'procedures,' 'packages,' 'synonyms,' and 'triggers

 

Bugs Fixed

  • 37566309 'Project Stage' duplicates 'APEX' folder in this directory
  • 37260262 Describe tables fails if there's a table of a synonym of the same name
  • 37603787 SQL aliases now support dashes
  • 37556899 'Project Stage' sometimes creates uncommented drops
  • 37692573 Project exports failed to close connection
  • 37747098 Change set ordering not working with stage in Windows
  • 37593892 Project stage sorting fails if add custom is called before stage
  • 37663113 Liquibase execution of PL/SQL with warnings causes Liquibase to exit
  • 37607778 Java app on large script sets memory leak
  • 37075680 Liquibase generate-schema not capturing status for triggers
  • 37734208 Pl/SQL package body with a drop statement incorrectly gets commented out

If your bug fix isn’t listed above, please refer to My Oracle Support to check its status.

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 using SQLcl is provided on the oracle.com website here.

Requirements

  • Supported Java Version
    • Oracle SQLcl requires Java 11 or 17 or 21. The supported Java Runtime Environments are:
      • Oracle Java 11
      • Oracle Java 17
      • Oracle Java 21
      • Oracle GraalVM Enterprise Edition for Java 11
      • Oracle GraalVM Enterprise Edition for Java 17
      • Oracle GraalVM Enterprise Edition for Java 21
  • JavaScript support requires Oracle Java 11 or GraalVM for Java 17 with the JavaScript Runtime Plugin

Restrictions

This section describes the restrictions on use.

ORACLE_HOME usage

When using an ORACLE_HOME or instant client with SQLcl, the client version must be 23ai.

Liquibase usage with APEX

Liquibase support for APEX requires APEX version 18 and above.

Feedback

In the forum, you can discuss topics with the SQLcl community around the world and leave feedback for the development team.

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.