SQLcl (Liquibase) (MOSC)

MOSC Banner

How to get SQLcl and Liquibase to export the change SQL?

in SQLcl (Liquibase) (MOSC) 7 commentsAnswered ✓

Hi,

I am using SQLcl 22.3.0.270.1258 (stand-alone, not from SQLDeveloper) on an Oracle 12.2 database and want to get the change DDL using Liquibase for this simple scenario:

  1. create a DDL baseline
  2. add a column to a table
  3. create the change DDL sql script

I have been watching several Youtube's and I am using the PDF of Oracle® SQLcl User's Guide Release 22.3 F61304-05 December 2022.

My questions are:

  1. do I need to install Liquibase, or is everything I need for that scenario included in the SQLcl version that I use?
  2. with what user should I login on the database?
  3. does that user require special privileges (besides those mentioned in the PDF)?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center