Table of Contents
- Title and Copyright Information
-
Preface
- Audience
- Documentation Accessibility
- Conventions
-
Third-Party License Information
- Antlr 3.1.3
- Apache Commons Codec 1.16-rc1
- Apache Commons Logging 1.2
- Apache httpmime 4.5.13
- Google Guava 31.1
- Apache Mina SSHD 2.9.2
- HttpComponents Http Client 5.1.3
- HttpCore 5.1.4
- jackson-annotations 2.13.4
- jackson-core 2.13.4
- jackson-databind 2.13.4.2
- jackson-jr-objects 2.13.4
- Jansi 2.4
- jLine 3.21.0
- Launch4j 3.14
- Liquibase 4.17.0
- StringTemplate 4.3.4
- 1 Changes in Release 22.4 for Oracle SQLcl User's Guide
-
2
Using Oracle SQLcl
- 2.1 Alphabetic List of SQLcl Commands
- 2.2 List of Unsupported SQL*Plus Commands and Features
- 2.3 Starting and Leaving SQLcl
- 2.4 Starting Up and Shutting Down a Database
- 2.5 Entering and Executing Commands
- 2.6 Manipulating SQL, SQLcl, and PL/SQL Commands
- 2.7 Formatting Query Results
- 2.8 Accessing Databases
-
2.9
Miscellaneous Commands
- 2.9.1 REST
- 2.9.2 SODA
- 2.9.3 MODELER
- 2.9.4 DG (Data Guard)
-
2.9.5
AQ (Advanced Queuing)
- 2.9.5.1 Create a Queue Table
- 2.9.5.2 Alter a Queue Table
- 2.9.5.3 Drop a Queue Table
- 2.9.5.4 Create a Queue
- 2.9.5.5 Alter a Queue
- 2.9.5.6 Drop a Queue
- 2.9.5.7 Create a Sharded Queue
- 2.9.5.8 Alter a Sharded Queue
- 2.9.5.9 Drop a Sharded Queue
- 2.9.5.10 Create an Exception Queue
- 2.9.5.11 Create a Transactional Event Queue
- 2.9.5.12 Alter a Transactional Event Queue
- 2.9.5.13 Drop a Transactional Event Queue
- 2.9.5.14 Create an EQ Exception Queue
- 2.9.5.15 Start a Queue
- 2.9.5.16 Stop a Queue
- 2.9.5.17 Add a Subscriber
- 2.9.5.18 Alter a Subscriber
- 2.9.5.19 Remove a Subscriber
- 2.9.5.20 Enqueue
- 2.9.5.21 Dequeue
- 2.9.6 SET system_variable value
- 2.9.7 SHOW option
- 2.10 Loading a File
- 2.11 Calling Oracle Cloud Infrastructure REST APIs Using the OCI Command
-
3
Using Liquibase
- 3.1 About Liquibase in SQLcl
- 3.2 Requirements for Using Liquibase
- 3.3 Supported Types
-
3.4
Supported Liquibase Commands
in SQLcl
- 3.4.1 calculate-checksum
- 3.4.2 changelog-sync
- 3.4.3 changelog-sync-sql
- 3.4.4 changelog-sync-to-tag
- 3.4.5 changelog-sync-to-tag-sql
- 3.4.6 clear-checksums
- 3.4.7 data
- 3.4.8 db-doc
- 3.4.9 diff
- 3.4.10 diff-changeLog
- 3.4.11 drop-all
- 3.4.12 future-rollback-count-sql
- 3.4.13 future-rollback-from-tag-sql
- 3.4.14 future-rollback-sql
- 3.4.15 generate-apex-object
- 3.4.16 generate-changelog
- 3.4.17 generate-control-file
- 3.4.18 generate-object
- 3.4.19 generate-ords-module
- 3.4.20 generate-ords-schema
- 3.4.21 generate-schema
- 3.4.22 history
- 3.4.23 list-locks
- 3.4.24 mark-next-changeset-ran
- 3.4.25 mark-next-changeset-ran-sql
- 3.4.26 release-locks
- 3.4.27 rollback
- 3.4.28 rollback-count
- 3.4.29 rollback-count-sql
- 3.4.30 rollback-sql
- 3.4.31 rollback-to-date
- 3.4.32 rollback-to-date-sql
- 3.4.33 snapshot
- 3.4.34 snapshot-reference
- 3.4.35 status
- 3.4.36 tag
- 3.4.37 tag-exists
- 3.4.38 unexpected-changesets
- 3.4.39 update
- 3.4.40 update-count
- 3.4.41 update-count-sql
- 3.4.42 update-sql
- 3.4.43 update-testing-rollback
- 3.4.44 update-to-tag
- 3.4.45 update-to-tag-sql
- 3.4.46 validate
- 3.4.47 version
- 3.5 Using SQLcl Liquibase Functionality with Open-Source Liquibase
- 3.6 Dynamic Object Transformation with SQLcl Liquibase and DBMS_METADATA Oracle Database Package
- 3.7 Liquibase Open-Source Changesets with SQLcl Liquibase
- 3.8 DATABASECHANGELOG_DETAILS VIEW
- 3.9 ChangeSets in Liquibase
- 3.10 Examples Using Liquibase
- 4 Using Cloud Storage
- 5 Using Data Pump
- 6 Using the Cloud Premigration Advisor Tool
- 7 Using the PGQL Plug-in
- A SQL Performance Troubleshooting