Skip to Main Content

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!

Batch script to delete records

LouieWarrenJan 24 2014 — edited Jan 24 2014

I have an Oracle 10 DB that I am "in charge of", however, there are other gov't DBAs that actually control it.    I am working with a tool that was developed by the previous contract winner and they are no help.  The tool I use allows for records to be created, and for the most part, edited.  However, there is no way to back out something if you make a mistake.   I was told by the gov't DBA to create a batch script with exactly the records I want deleted and he'd run it.    There are 16 tables and the criteria is the same for each; a specific date, and userID is the same for each record.... 

DELETE FROM Table1 WHERE DATE = '01-24-2014'  and USERID = 'Me';   I need to do that 16 times and only change the table name.    I haven't written a script in 15 years and old age is messing with me.   Anyone have a suggestion?  Thank you in advance.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 21 2014
Added on Jan 24 2014
7 comments
1,292 views