1 Changes in Release 26.1 for Oracle SQLcl User's Guide

The new features and enhancements in this release are:

• Extended CONNMGR command to provide a mechanism for exporting or importing stored database connections.

  See Export Connections and Import Connections

• Included support for schema substitution thereby enabling you to use the project command to parameterize hard-coded schema names in database scripts for dynamic environment handling.

  See Support for Schema Substitution

• A new command to compare two Oracle Database schemas and generate an artifact file containing the necessary changes to synchronize them.

  See DIFF

• The new script execution diagnostic commands, SHOW LEVEL and SHOW SCRIPTS, to help understand and audit the execution context and structure of SQL scripts.

  See SHOW LEVEL and SHOW SCRIPTS

• The new SHOW KEYMAP command to display the key bindings (shortcuts) associated with all supported editor modes (such as vicmd, viins, visual, or emacs) in Oracle SQLcl.

  See SHOW KEYMAP

• Extended ORAPKI to enable downloading the TLS certificate chain from an HTTPS endpoint and adding it to an existing Oracle wallet as trusted certificates.

  See ADD

• The new OBJECTSTORAGE command to use the Object Storage Service API to manage objects, and related resources.

  See OBJECTSTORAGE

• The new options for the project release command to include or exclude the specified changes from the release.

  See release

• Extended the project export command to include both scheduler job and program arguments while exporting jobs.

  See Support for Jobs