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!

How to validate SQL scripts

936666May 7 2013 — edited May 8 2013

Hi,
How to Validate SQL scripts?
I am having set of sql files i wish to run one by one if there is any error at one file i need to notify to the user.I have created Bat file in-order to execute in a sequence.how to validate in bat file
say

01.sql ---Sucess
02.sql --- Fail -- intimate and not to execute rest of sql files
03.sql
04.sql

Thanks!

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 5 2013

Added on May 7 2013

#general-database-discussions, #oracle, #sql

34 comments

5,337 views