Oracle Database Discussions

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!

running multiple queries in a single bat file.

$phinx19Oct 28 2013

Hi All,

I am trying to make a batch file to run three queries in succession. Following is the sample for the same, the thing is that when I am trying to run this batch file, it is only able to execute the first query and the remaining 2 queries are skipped by the batch file.

>sqlplus username/abcd@xyz "@Insert_Script.sql" "@EOD_SCRIPT.sql" "@Pre_EOD_Script.sql"

>pause

What am I missing here?

Regards,

Sphinx

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 25 2013

Added on Oct 28 2013

#general-database-discussions

0 comments

306 views