Oracle SQLcl 25.4 Release Notes

New Features

MCP Updates

• run-sql, asynchronous queries
  • The run-sql tool supports submitting a query to be ran on a background task. The agent will be given a job-id that can be used to retrieve the results of the query or script at a latter point in time.
• Configuration
  • A new argument -home allows you to specify the directory where your database connections will be stored. This allows for a developer to use one set of connections for regular work via SQL Developer Extension for VS Code and SQLcl, and another set of database connections specifically for their AI Agents via our MCP Server.

Project Enhancements

• Object Support
  • CI/CD support for DBMS_SCHEDULER now includes:
    • Job classes
    • Scheduler groups
    • Chains
• Verifications
  • project verify allows you to validate the structure of your project. We've added many new tests for your project
    • Enforce the use of the correct named connection whenever a project command is executed
    • Respect the version of SQLcl the project requires
    • Validate the source code formatter rules
    • Validate syntactic and semantic errors for filters used in export
    • Ensure there are no change entries pointing to files that don't exist or to files outside of the current change folder
    • Ensure there are no duplicate release pointers in the main changelog file, no duplicate changelog pointers across ALL releases, no duplicate file pointers across ALL changelogs in ALL releases
    • Ensure that all changes to files under src/database are accounted for by changes in the current ticket
    • Verify the structure of the project folders depending on the SoftObjectIsolation value
    • Verify that value of SoftObjectIsolation is not modified during a release

SQL History

• Incremental search, alt+r enter search term, ctrl+R to execute
• Automatic Suggestions, e.g. SET AUTOSUGGESTIONS on as you type a query, if we find a match in the SQL History you will see the suggested statement to complete, activate by using Right Arrow key

VERSION command

Version, replaces 'show version,' displays the version of SQLcl and can also be used to prevent a version of SQLcl being used not in an approved list.

• version
• version -check-in 25.2.0,25.3.0,25.4

Console/Editor Improvements

• Tab completion for SQLcl command and command arguments set linenumbers on/off - Provides flexible control over line number visibility in multi-line SQL statements. On by default.
• Help for all commands has been updated from a simple list of all commands to a more verbose list of the commands and a high level description of the command. This help is paginated automatically and is searchable using /search term.

  For help on a topic type help
  
  <topic>
  List of Help topics 
  /                  Executes the most recently executed SQL command or PL/SQL block which is stored in the SQL 
  @                  Runs the SQLcl statements in the specified script. The script can be called from the local file system or a web 
  @@                 Runs the specified script. This command is almost identical to the @ command. It is useful for running nested scripts because it has the additional functionality of looking for the nested script in the same url or path as the calling script
  ACCEPT             Reads a line of input and stores it in a given substitution variable
  ALIAS              Alias is a command which allows you to save a sql, plsql or sqlplus script and assign it a shortcut command
  APEX               Export APEX Applications

25.4 Bugs Fixed

Projects

• 38620219 project export does not respect session edition (EBR)
• 38716180 project export adds trailing semicolon (;) to view DDL
• 38651814 project export does not sort unique indexes consistently
• 38688471 project stage recreates ORDS modules vs updates even if already exists
• 38688658 project stage generates incorrect ALTER DDL when column has DEFAULT value
• 38688658 Project stage now generates correct alters for changes to tables with 'not null' columns
• 38581517 project deploy does not generate log files on Windows

Liquibase

• 38743930 updates for packages, package bodies, and synonyms have incorrect DDL
• 38655790 generate-schema -split -sql fails in Windows CMD terminal
• 38303058 generate-schema including FLASHBACK DATA ARCHIVE (FDA) INDEXES
• 38654885 table column changes not being picked up
• 38566458 quoted schema names cause generated objects to be unusable

General

• 38412159 set define off after a merge statement causes re-execution of MERGE
• 33094416 BREAK on multiple columns now works in SQLcl (E.g., BREAK ON COLUMN_N)
• 38566458 Script parsers now recognize comments at the end of a PLSQL unit
• 38538544 apex export -exptype readable_yaml fails
• 38536583 SPOOL now respects SET HEADING OFF in ansiconsole format

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 17 or 21. The supported Java Runtime Environments are:
    • Oracle Java 17
    • Oracle Java 21
    • Oracle GraalVM Enterprise Edition for Java 17
    • Oracle GraalVM Enterprise Edition for Java 21
• JavaScript support requires 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.