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?