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

Home -> Community -> Usenet -> c.d.o.server -> Re: How would you delete the values returned by an sql query?

Re: How would you delete the values returned by an sql query?

From: Krish <Krishna.Bussu_at_gmail.com>
Date: 5 Feb 2007 12:40:40 -0800
Message-ID: <1170708040.452901.35760@k78g2000cwa.googlegroups.com> 





Here is the example:



SQL>DELETE FROM (SELECT  * FROM T WHERE TCOL IN ( SELECT  TTCOL FROM

TT));



I tried this in 10G R2 and worked fine.



Do post the exact SQL and the ERROR message and ur version if it still
an issue.



Krish.
Received on Mon Feb 05 2007 - 14:40:40 CST












Original text of this message













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