Deletion of record from more than one table

[gurusamy sengodan]

Hi 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

[Mark Spritzler]

That is true, you have to have a delete statement for each table. So 50 delete statements.

Mark