-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|