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!

delete records which are related to another table

user598242Sep 7 2010 — edited Sep 7 2010
I want to delete some records from a table(A), these records has some relationship with another table(B)

using a query to define these A records that i want to delete

with B as
(
select '2' f, '3' l from dual
union all
select '3' f, '2' l from dual
union all
select '4' f, '4' l from dual
)


select * from A, B
where B.f>3 and B.l>3
and A.f=B.f
and A.l=B.l

Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production


Thanks in advance!
This post has been answered by Frank Kulash on Sep 7 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 5 2010
Added on Sep 7 2010
3 comments
962 views