SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to create Maste Scrpt to call/execute other sql file

User_GTJEPJun 10 2015 — edited Jun 10 2015

Hi,

Can you please help me on below.

I have 10 different .sql file and wanted to execute in a sequence from another .sql file. Need sample file which I can refer to create my master sql file to call anothere Stored proc or .sql to comiple.

like :

a.sql

b.prc

c.pkh

c.pkb

d.sql

watnted to execute these file from another .sql file, do i need to mention path, if so then how to define path, how to execute from another file. all stps.

looking forward , thanks in advance

Thanks,

Rob

This post has been answered by Frank Kulash on Jun 10 2015

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 8 2015

Added on Jun 10 2015

1 comment

992 views