Oracle SQLcl 26.1.2 Release Notes

Oracle SQLcl 26.2 Release Notes

July 2026

 

New Features

  • SQLcl Projects now support APEXLang applications.
  • Shell execution for SQLcl commands
    • SQLcl commands can be run from the shell with repeatable `-e` or `-execute` options before SQLcl exits.
    • Example: `sql -e 'select date' -e 'select user' -name myconn`.
  • SQLcl project stage changelog processing has improved performance and error handling.
  • Project release adds Liquibase tags for generated release changelogs.
  • All keyboard shortcuts are now fully customizable.
    • Example: `KEYMAP bind emacs ^E history-incremental-search-backward` binds Ctrl-E to reverse history search in Emacs mode.
  • SET now supports default values.
    • SET now supports default values.

Bugs Fixed

  • `DIFF` artifact output paths outside the current working directory.
  • Project stage 'revoke generation' for object names that contain the substring to '.'
  • Project changelog generation so object grants are ordered after their referenced objects.
  • Project stage output so action comments are preserved in generated changelogs.
  • Project stage failures when SQLcl snapshot metadata contains large SXML text.
  • SQLcl project deploy so generated Oracle APEX deploy controllers apply fixed import offsets.
  • Oracle APEX export so existing files are not overwritten unless `-overwrite-files` is specified.
  • Oracle APEX component export so multiple export types create all requested files.
  • Command help navigation when using command aliases.
  • `DESCRIBE` output for object types so method signatures are shown.
  • `DESCRIBE` behavior for synonyms whose target object is not visible to the current user.
  • SQLcl startup so Oracle Cloud Infrastructure profile refresh failures do not terminate command startup.
  • Liquibase formatted SQL execution so PL/SQL blocks and colon-containing comments run correctly with the default engine.
  • Liquibase action logging so `DATABASECHANGELOG_DETAILS` is recreated as a valid view during update repair.
  • Liquibase action logging for long SQL and SXML changeset content.

 

Supported Java Versions

  • Oracle Java 17, 21 or Java 25
  • Local JavaScript scripting support requires a supported GraalVM runtime with the JavaScript Plugin.