Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Where EXISTS in a delete statement

626362Mar 11 2008 — edited Mar 11 2008
Can I use Where EXISTS in a delete statement.

delete from table a
where exists ( select 1
from table b
where a.col1 = b.col1
and ...) ?

Is that more efficient than

delete from table a
where a.col1 in ( select b.col1
from table b
where ......)
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 8 2008
Added on Mar 11 2008
4 comments
1,560 views