Table of Contents
- Title and Copyright Information
- Preface
- 1 Changes in Release 24.4 for Oracle SQLcl User's Guide
-
2
Using Oracle SQLcl
- 2.1 Starting and Leaving SQLcl
- 2.2 About the CONNECT Command
- 2.3 Managing Stored Connections
- 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 Loading a File
- 2.10 Using the OCI Command for Oracle Cloud Infrastructure REST APIs
- 2.11 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 Examples Using Liquibase
- 4 Database Application CI/CD
- 5 Using Cloud Storage
- 6 Using Data Pump
- 7 Using the Cloud Premigration Advisor Tool
- 8 Using the PGQL Plug-in
-
9
SQLcl Command
Reference
- 9.1 Alphabetic List of SQLcl Commands
- 9.2 Additional Commands
-
9.3
AQ (Advanced Queuing)
- 9.3.1 Create a Queue Table
- 9.3.2 Alter a Queue Table
- 9.3.3 Drop a Queue Table
- 9.3.4 Create a Queue
- 9.3.5 Alter a Queue
- 9.3.6 Drop a Queue
- 9.3.7 Create a Sharded Queue
- 9.3.8 Alter a Sharded Queue
- 9.3.9 Drop a Sharded Queue
- 9.3.10 Create an Exception Queue
- 9.3.11 Create a Transactional Event Queue
- 9.3.12 Alter a Transactional Event Queue
- 9.3.13 Drop a Transactional Event Queue
- 9.3.14 Create an EQ Exception Queue
- 9.3.15 Start a Queue
- 9.3.16 Stop a Queue
- 9.3.17 Add a Subscriber
- 9.3.18 Alter a Subscriber
- 9.3.19 Remove a Subscriber
- 9.3.20 Enqueue
- 9.3.21 Dequeue
- 9.4 AWR
- 9.5 BLOCKCHAIN_TABLE
- 9.6 DG (Data Guard)
- 9.7 DIRS, PUSHD and POPD
- 9.8 MDB
- 9.9 MLE
- 9.10 MODELER
- 9.11 REST
- 9.12 SET system_variable value
- 9.13 SHOW option
- 9.14 SODA
- 9.15 List of Unsupported SQL*Plus Commands and Features
- A SQL Performance Troubleshooting
-
B
Third-Party License Information
- B.1 ANTLR4 Java Runtime 4.13.1
- B.2 Apache Mina SSHD-contrib 2.13.2
- B.3 Apache Mina SSHD-osgi 2.13.2
- B.4 Apache Mina SSHD-putty 2.13.2
- B.5 Apache Mina SSHD-scp 2.13.2
- B.6 Apache Mina SSHD-sftp 2.13.2
- B.7 Commons IO 2.16.1
- B.8 Commons Text 1.12.0
- B.9 Eclipse Parsson 1.1.7
- B.10 Google Guava 33.2.1-jre
- B.11 HttpComponentsCore 5.2.4
- B.12 HttpComponents Http Client 5.3.1
- B.13 httpcore5 5.2.4
- B.14 jackson-annotations 2.17.2
- B.15 jackson-core 2.17.2
- B.16 jackson-databind 2.17.2
- B.17 jackson-jr-objects 2.17.2
- B.18 jackson-jr-stree 2.16.1
- B.19 jakarta.json-api 2.1.3
- B.20 JLine 3.25.1, 3.26.3
- B.21 Jansi 2.4.1
- B.22 json-base 2.4.3
- B.23 json-flattener 0.16.6
- B.24 liquibase-core 4.25.0
- B.25 OCI SDK for Java 3.44.3
- B.26 org.eclipse.jgit 6.10.0.202406032230-r
- B.27 slf4j-api 2.0.13
- B.28 slf4j-jdk14 2.0.13
- B.29 StringTemplate 4.3.4
- B.30 ucanaccess 5.1.1