Oracle SQLcl 24.4.1 Release Notes

Version 24.4.1.042.1221

February 12, 2025

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

Enhancements

Projects

  • Improved object sorting for change generation ordering in changelogs

General

  • Load command modified to support loading data from Excel
  • Load command now supports relative paths
  • REPEAT command now respects "WHENEVER SQL ERROR"
  • Connection widget on status bar supports stored connection names
  • MLE command can now load external dependent javascript libraries
  • DDL command now respects "feedback" settings
  • DDL command now supports "QUEUE" tables
  • Codescan now supports adding rules to ignore during a scan

Issues Fixed

  • 37288796 Set sqlformat now supports "Tab Delimited" and "TEXT format" explicitly
  • 33972218 BREAK on multiple columns now produces the right results
  • 37228784 Connections with a role now supports SYSBACKUP , SYSDG , SYSRAC & SYSKM
  • 37068930 Load command properly identifies line breaks in CSV formats
  • 36229885 Liquibase now works correctly with proxy users
  • 37155086 Generate schema now removes "start by" clause from sequence generation

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.

Oracle Chatbot
Disconnected