delete the records from 50 tables based on the common column.
556055Jan 13 2007 — edited Jan 13 2007Hi there,
I am having 50 tables which are all having one column name same.
i want to delete the records from 50 tables based on the common column.
Example:-
delete from E2B_SAFETY_REPORT,E2B_LINKEDREPORT where CASE_IDENTIFIER_NO in (select CASE_IDENTIFIER_NO from AGX_CASE_DISTRIBUTION_INFO where DISTRIBUTION_ID='235')
while i am executing the above command i got the following msg.
ORA-00933: SQL command not properly ended.
i think in delete command after from we cannot give more than one table.
Please tell me solution. It's very urgent
Thanks
Gurusamy