Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Alternative way to write delete query

Re: Alternative way to write delete query

From: Chip <>
Date: Thu, 29 May 2003 20:56:07 -0800
Message-ID: <>

delete from table_a a
where exists
( select null
  from table_b b
  where a.column = b.col_a
  or a.column = b.col_b

Have Fun :)

Mark Richard wrote:

>Hi List,
>I'm having a mental blank and looking for suggestions... I'm trying to
>remember alternative ways to write the below query:
>delete from table
>where column in (select col_a
> from table_b
> union all
> select col_b
> from table_b);
>Having said that, I don't mind if you simplify the nested query down to
>"select col_a from table_b" even. I just have a feeling that I've seen an
>equivalent query written totally differently but I can't remember how. I
>have a feeling it effectively allows more than one table to be mentioned in
>the delete without needing a nested query (like the options available in
>normal selects).
>Any suggestions?
> Mark.
> Privileged/Confidential information may be contained in this message.
> If you are not the addressee indicated in this message
> (or responsible for delivery of the message to such person),
> you may not copy or deliver this message to anyone.
>In such case, you should destroy this message and kindly notify the sender
> by reply e-mail or by telephone on (61 3) 9612-6999.
> Please advise immediately if you or your employer does not consent to
> Internet e-mail for messages of this kind.
> Opinions, conclusions and other information in this message
> that do not relate to the official business of
> Transurban City Link Ltd
> shall be understood as neither given nor endorsed by it.

Please see the official ORACLE-L FAQ:
Author: Chip

Fat City Network Services    -- 858-538-5051
San Diego, California        -- Mailing list and web hosting services
To REMOVE yourself from this mailing list, send an E-Mail message
to: (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Thu May 29 2003 - 23:56:07 CDT

Original text of this message