Table of Contents
- Title and Copyright Information
-
Preface
- Audience
- Documentation Accessibility
- Conventions
-
Third-Party License Information
- Antlr 3.1.3
- Apache Commons Codec 1.15
- Apache Commons Logging 1.2
- Apache httpmime 4.5.13
- Google Guava 31.1
- Apache Mina SSHD 2.8.0
- HttpComponents Http Client 5.1.3
- HttpCore 5.1.3
- jackson-annotations 2.13.2
- jackson-core 2.13.2
- jackson-databind 2.12.4
- jackson-jr-objects 2.13.2
- Jansi 2.4
- jLine 3.21.0
- Launch4j 3.14
- Liquibase 4.9.1
- StringTemplate 4.3.1, 4.3.3
- 1 Changes in Release 22.2 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 LB GENOBJECT
- 3.4.2 LB GENSCHEMA
- 3.4.3 LB GENCONTROLFILE
- 3.4.4 LB UPDATE
- 3.4.5 LB UPDATESQL
- 3.4.6 LB ROLLBACK
- 3.4.7 LB ROLLBACKSQL
- 3.4.8 LB DIFF
- 3.4.9 LB DBDOC
- 3.4.10 LB CHANGELOGSYNC
- 3.4.11 LB CLEARCHECKSUMS
- 3.4.12 LB LISTLOCKS
- 3.4.13 LB RELEASELOCKS
- 3.4.14 LB STATUS
- 3.4.15 LB VALIDATE
- 3.4.16 LB VERSION
- 3.4.17 LB HELP
- 3.5 DATABASECHANGELOG_DETAILS VIEW
- 3.6 ChangeSets in Liquibase
- 3.7 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