Hi

Can we delete rows from multiple tables with a single query (like we are retrieving rows from multiple tables using select statement) ?

for example:

these are my tables

SQL> select * from test12;

ID NAME
--------- ----------
100 srini
200 venu
300 vega

SQL> select * from test13;

ID ADDRESS
--------- ----------
300 add1
200 add2
100 add3


and i have tried to delete as follows

SQL> delete test12,test13 where test12.id=300 and test12.id=test13.id;
delete test12,test13 where test12.id=300 and test12.id=test13.id
*
ERROR at line 1:
ORA-00933: SQL command not properly ended


this is the problem


thanks for any help

SrinivasM