UNIX SQL script delete

I have a UNIX shell script that calls an sql file.  In the sql file I have:

delete from tableA where fw_insert_date < sysdate-30
delete from   tableB  where insert_date < sysdate-30
delete from   tableC  where insert_date < sysdate-30

The shell script calls the SQL script but nothing happens. What do I need to add to the SQL file to make this work?
Who is Participating?
GGuzdziolConnect With a Mentor Commented:
Semicolon after each individual statement? If this is not the case - please show script's and sql file's actual code...
delete from tableA where fw_insert_date < sysdate-30;
delete from tableB where insert_date < sysdate-30;
delete from tableC where insert_date < sysdate-30;

Open in new window

Just to be on the safe side if your database is production...

I recommed that you take out commit from your script and add SQL statement to give you row count before and after the delete with output (spool file). Verify deleted rows and then issue commit outside of the script.

What does the shell script look like?
Naveen KumarProduction Manager / Application Support ManagerCommented:
does the sql statements work if you run them in the sql> prompt directly.

If yes, then may be missing ; is the only thing which i can think of.

If no, then first you need to check why there are not working ( resolve the errors if you are getting any ).

jjc_mnAuthor Commented:
The semi-colons were what I was missing. Thanks all.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.