Skip to content

sqlcl_commands.md

Latest commit

 

History

History
32 lines (17 loc) · 615 Bytes

sqlcl_commands.md

File metadata and controls

32 lines (17 loc) · 615 Bytes

SQLcl commands

0. Connect in thin mode

sql -thin hr/Oracle01@pdb1

1. Initialize SQLcl project

SQL> project init -name <project> -schemas <schema>

2. Export DB objects

SQL> project export

3. "Copy" everything from src to dist

This will generate the scripts and Liquibase changelogs for the brach.

SQL> project stage

4. Cut a release

SQL> project release -version <version>

5. Generate artifact

SQL> project gen-artifact -version <version>

6. Deploy to production

SQL> connect - name <environment>
SQL> project deploy -file <artifact>