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: <redrosekrs_at_yahoo.com>
Date: 5 Feb 2007 14:00:15 -0800
Message-ID: <1170712815.180090.304050@s48g2000cws.googlegroups.com>


Oh, Good point. I guess I need the code for the actual query, which I don't have access to. I was literally typing in Delete from Query1, I don't know the sql syntax for Query1 though.

On Feb 5, 12:40 pm, "Krish" <Krishna.Bu..._at_gmail.com> wrote:
> 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 - 16:00:15 CST

Original text of this message

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