Table of Contents
- Title and Copyright Information
- Preface
- 1 Changes in Release 25.1 for Oracle SQLcl User's Guide
-
2
Using Oracle SQLcl
- 2.1 Starting and Leaving SQLcl
- 2.2 Defining Parameters in SQLcl Scripts Using the ARGUMENT Command
- 2.3 Starting Up and Shutting Down a Database
- 2.4 Entering and Executing Commands
- 2.5 Manipulating SQL, SQLcl, and PL/SQL Commands
- 2.6 Formatting Query Results
- 2.7 Connecting to a Database
- 2.8 Loading a File
- 2.9 Using the OCI Command for Oracle Cloud Infrastructure REST APIs
-
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.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
AQ (Advanced Queuing)
- 9.1.1 Create a Queue Table
- 9.1.2 Alter a Queue Table
- 9.1.3 Drop a Queue Table
- 9.1.4 Create a Queue
- 9.1.5 Alter a Queue
- 9.1.6 Drop a Queue
- 9.1.7 Create a Sharded Queue
- 9.1.8 Alter a Sharded Queue
- 9.1.9 Drop a Sharded Queue
- 9.1.10 Create an Exception Queue
- 9.1.11 Create a Transactional Event Queue
- 9.1.12 Alter a Transactional Event Queue
- 9.1.13 Drop a Transactional Event Queue
- 9.1.14 Create an EQ Exception Queue
- 9.1.15 Start a Queue
- 9.1.16 Stop a Queue
- 9.1.17 Add a Subscriber
- 9.1.18 Alter a Subscriber
- 9.1.19 Remove a Subscriber
- 9.1.20 Enqueue
- 9.1.21 Dequeue
- 9.2 AWR
- 9.3 BACKGROUND
-
9.4
BLOCKCHAIN_TABLE
- 9.4.1 add_interval_partitioning
- 9.4.2 countersign_row
- 9.4.3 desc
- 9.4.4 delete_expired_rows
- 9.4.5 get_bytes_for_row_hash
- 9.4.6 get_bytes_for_row_signature
- 9.4.7 get_digest
- 9.4.8 get_signed_digest
- 9.4.9 sign_row
- 9.4.10 sign_row_with_countersignature
- 9.4.11 verify_rows
- 9.4.12 verify_table
- 9.4.13 verify_user_chains
- 9.5 CERTIFICATE
- 9.6 CODESCAN
- 9.7 CONNECT
- 9.8 CONMGR
- 9.9 DG (Data Guard)
- 9.10 DIRS, PUSHD and POPD
- 9.11 IMMUTABLE_TABLE
-
9.12
LIQUIBASE
- 9.12.1 calculate-checksum
- 9.12.2 changelog-sync
- 9.12.3 changelog-sync-sql
- 9.12.4 changelog-sync-to-tag
- 9.12.5 changelog-sync-to-tag-sql
- 9.12.6 clear-checksums
- 9.12.7 data
- 9.12.8 db-doc
- 9.12.9 diff
- 9.12.10 diff-changeLog
- 9.12.11 drop-all
- 9.12.12 future-rollback-count-sql
- 9.12.13 future-rollback-from-tag-sql
- 9.12.14 future-rollback-sql
- 9.12.15 generate-apex-object
- 9.12.16 generate-changelog
- 9.12.17 generate-controlfile
- 9.12.18 generate-db-object
- 9.12.19 generate-ords-module
- 9.12.20 generate-ords-schema
- 9.12.21 generate-schema
- 9.12.22 history
- 9.12.23 list-locks
- 9.12.24 mark-next-changeset-ran
- 9.12.25 mark-next-changeset-ran-sql
- 9.12.26 release-locks
- 9.12.27 rollback
- 9.12.28 rollback-count
- 9.12.29 rollback-count-sql
- 9.12.30 rollback-sql
- 9.12.31 rollback-to-date
- 9.12.32 rollback-to-date-sql
- 9.12.33 snapshot
- 9.12.34 status
- 9.12.35 tag
- 9.12.36 tag-exists
- 9.12.37 unexpected-changesets
- 9.12.38 update
- 9.12.39 update-count
- 9.12.40 update-count-sql
- 9.12.41 update-sql
- 9.12.42 update-testing-rollback
- 9.12.43 update-to-tag
- 9.12.44 update-to-tag-sql
- 9.12.45 validate
- 9.12.46 version
- 9.13 MDB
- 9.14 MLE
- 9.15 MODELER
- 9.16 PROJECT
- 9.17 REST
- 9.18 SDK
- 9.19 SET system_variable value
- 9.20 SHOW option
- 9.21 SODA
-
9.1
AQ (Advanced Queuing)
- A List of Unsupported SQL*Plus Commands and Features
- B SQL Performance Troubleshooting
-
C
Third-Party License Information
- C.1 ANTLR4 Java Runtime 4.13.1
- C.2 Apache Mina SSHD-contrib 2.13.2
- C.3 Apache Mina SSHD-osgi 2.13.2
- C.4 Apache Mina SSHD-putty 2.13.2
- C.5 Apache Mina SSHD-scp 2.13.2
- C.6 Apache Mina SSHD-sftp 2.13.2
- C.7 Commons IO 2.16.1
- C.8 Commons Text 1.12.0
- C.9 Eclipse Parsson 1.1.7
- C.10 Google Guava 33.2.1
- C.11 HttpComponentsCore 5.2.4
- C.12 HttpComponents Http Client 5.3.1
- C.13 httpcore5 5.2.4
- C.14 jackson-annotations 2.17.2
- C.15 jackson-core 2.17.2
- C.16 jackson-databind 2.17.2
- C.17 jackson-jr-objects 2.17.2
- C.18 jakarta.json-api 2.1.3
- C.19 JLine 3.26.3
- C.20 Jansi 2.4.1
- C.21 json-base 2.4.3
- C.22 json-flattener 0.16.6
- C.23 liquibase-core 4.25.0
- C.24 OCI SDK for Java 3.57.1
- C.25 org.eclipse.jgit 6.10.0.202406032230-r
- C.26 slf4j-api 2.0.13
- C.27 slf4j-jdk14 2.0.13
- C.28 StringTemplate 4.3.4
- C.29 ucanaccess 5.1.1