Executing multiple oracle sql statement in a single go from different script.sql file.s

Question

can you please point me a guide line for the following situation.

I will create a user/schema, a tablespace for that schema.
Then will create sequence [I have script in a separate sql file]
Then will create table and triggers [I have script in a separate sql file]
Then will create Type [I have script in a separate sql file]
Then will create Function [I have script in a separate sql file]
Then will create Views [I have script in a separate sql file]
Then will create StoredProcedures [I have script in a separate sql file]
and may be packages.
I also will have insert statement for all the tables above [separate script]

I have taken the scripts for all of the items above except user/schema and Tablespace.

What now I want is, I will have a MasterScript file, where I will mention my user/schema name and table space and all the script file above.

If I ran the MasterScript file that will handle/execute all the other script file from sql command prompt.

Can someone point me how can I achieve that?

Incognito · Accepted Answer · 2014-01-22 11:05:54Z

1

You can embed the calls to the individual SQL files into your master SQL file, preserving the order in which they should be executed (DDLs follwed by DMLs, taking care of constraints and referential intergrities, if any)

You master script (let's call it master.sql for sake of brevity) will contain entries like:

@{Path}/create_sequences.sql

@{Path}/create_tables.sql

and so on, for all the scripts which you have created so far. You jsut have to call the script which you want to execute by appending @ to the script path

answered Jan 22, 2014 at 11:05

Incognito

3,1043 gold badges30 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Shahidul Haque Over a year ago

Yes, the way I thought, so after connecting to Oracle, I will execute the MasterScript.sql file like @MasterScript.sql, that will resolve my issue, right??

Incognito Over a year ago

Yes, it will. Give it a try

Collectives™ on Stack Overflow

Executing multiple oracle sql statement in a single go from different script.sql file.s

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related