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

This section lists the changes for this release.

New Features

New features in this release are:

• The SQLcl extension now supports the use of Liquibase contexts and labels enabling more flexibility in its usage.

  • Job and Directory are new supported DDL types.

  • CreateOracleJob and CreateOracleDirectory are new Liquibase changesets.

• Changes in syntax for the following Liquibase commands: GENOBJECT, GENSCHEMA, UPDATE, UPDATESQL, ROLLBACK, DIFF.

• New Liquibase commands exposed in SQLcl:

  • ROLLBACKSQL
  • DBDOC
  • VERSION

• DATABASECHANGELOG_DETAILS is a new view in Liquibase. See DATABASECHANGELOG_DETAILS VIEW

• New load options available: SET LOAD and SET LOADFORMAT

  See the LOAD command in Miscellaneous Commands

• A new Property Graph Query Language (PGQL) plug-in for SQLcl.

  See PGQL Plug-in for SQLcl