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.