Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Deleting records where they are in another table

Re: Deleting records where they are in another table

From: Anurag Varma <avoracle_at_gmail.com>
Date: 30 May 2006 08:37:26 -0700
Message-ID: <1149003446.328926.269580@g10g2000cwb.googlegroups.com> 






ORA92> delete (select a.* from testA a, testB b where a.id = b.id and
a.d1 = b.d1);



26 rows deleted.



... should work provided the tables have a PK on the id and date
columns....



Anurag
Received on Tue May 30 2006 - 10:37:26 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US