Table of Contents
- Title and Copyright Information
- Preface
- 1 Changes in Release 24.1 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 Connecting to a Database
- 2.5 Managing Stored Connections
- 2.6 Starting Up and Shutting Down a Database
- 2.7 Entering and Executing Commands
- 2.8 Manipulating SQL, SQLcl, and PL/SQL Commands
- 2.9 Formatting Query Results
- 2.10 Accessing Databases
-
2.11
Miscellaneous Commands
- 2.11.1 REST
- 2.11.2 SODA
- 2.11.3 MODELER
- 2.11.4 DG (Data Guard)
-
2.11.5
AQ (Advanced Queuing)
- 2.11.5.1 Create a Queue Table
- 2.11.5.2 Alter a Queue Table
- 2.11.5.3 Drop a Queue Table
- 2.11.5.4 Create a Queue
- 2.11.5.5 Alter a Queue
- 2.11.5.6 Drop a Queue
- 2.11.5.7 Create a Sharded Queue
- 2.11.5.8 Alter a Sharded Queue
- 2.11.5.9 Drop a Sharded Queue
- 2.11.5.10 Create an Exception Queue
- 2.11.5.11 Create a Transactional Event Queue
- 2.11.5.12 Alter a Transactional Event Queue
- 2.11.5.13 Drop a Transactional Event Queue
- 2.11.5.14 Create an EQ Exception Queue
- 2.11.5.15 Start a Queue
- 2.11.5.16 Stop a Queue
- 2.11.5.17 Add a Subscriber
- 2.11.5.18 Alter a Subscriber
- 2.11.5.19 Remove a Subscriber
- 2.11.5.20 Enqueue
- 2.11.5.21 Dequeue
- 2.11.6 SET system_variable value
- 2.11.7 SHOW option
- 2.12 Loading a File
- 2.13 Calling Oracle Cloud Infrastructure REST APIs Using the OCI Command
- 2.14 Running Tasks in the Background
-
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-controlfile
- 3.4.18 generate-db-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 status
- 3.4.35 tag
- 3.4.36 tag-exists
- 3.4.37 unexpected-changesets
- 3.4.38 update
- 3.4.39 update-count
- 3.4.40 update-count-sql
- 3.4.41 update-sql
- 3.4.42 update-testing-rollback
- 3.4.43 update-to-tag
- 3.4.44 update-to-tag-sql
- 3.4.45 validate
- 3.4.46 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 Tips for Liquibase Settings
- 3.11 Important 23.4 Update with Liquibase Changelog Files
- 3.12 Known Issues
- 3.13 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
-
B
Third-Party License Information
- B.1 ANTLR4 Java Runtime 4.13.1
- B.2 Apache Mina SSHD-contrib 2.12
- B.3 Apache Mina SSHD-osgi 2.12.0
- B.4 About PGQL Commands
- B.5 Apache Mina SSHD-osgi 2.12.0
- B.6 Eclipse Parsson
- B.7 Examples
- B.8 jackson-jr-stree 2.16.1
- B.9 jakarta.json-api 2.1.3
- B.10 ANTLR4 Java Runtime 4.13.1
- B.11 Jansi 2.4.1
- B.12 OCI SDK for Java 3.33.0
- B.13 Apache Mina SSHD-contrib 2.12
- B.14 Apache Mina SSHD-putty 2.12
- B.15 Apache Mina SSHD-scp 2.12
- B.16 Apache Mina SSHD-sftp 2.12
- B.17 Apache Mina SSHD-putty 2.12
- B.18 Apache Mina SSHD-scp 2.12
- B.19 Apache Mina SSHD-sftp 2.12
- B.20 Eclipse Parsson
- B.21 Google Guava 33.0.0
- B.22 HttpComponents Http Client 5.3.1
- B.23 HttpComponentsCore 5.2.4
- B.24 jackson-annotations 2.16.1
- B.25 jackson-core 2.16.1
- B.26 jackson-jr-objects 2.16.1
- B.27 jackson-jr-stree 2.16.1
- B.28 jakarta.json-api 2.1.3
- B.29 Jansi 2.4.1
- B.30 jLine 3.25.1
- B.31 liquibase-core 4.26.0
- B.32 OCI SDK for Java 3.33.0
- B.33 StringTemplate 4.3.4