-
Hi,
Can't I use the joins in the delete statement. If possible, could someone give me the syntax for deleting from table a and table b where a.account_num = b.account_num.
Badrinath
-
use the on delete cascade feature of the foreign key so oracle automatically deletes the rows in the child table when rows in the parent table are deleted.else you gotta use database triggers for accomlishing the same
-
Try the following
delete from abc where no in (select no from def where no = 1);
Beware this can be slow on large tables.
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
|