Re: pl/sql
From: Guang Mei <gmei_at_proteome.com>
Date: Fri, 18 May 2001 16:56:05 -0400
Message-ID: <C%fN6.1055$du2.100371_at_news.shore.net>
Date: Fri, 18 May 2001 16:56:05 -0400
Message-ID: <C%fN6.1055$du2.100371_at_news.shore.net>
Hi:
use
delete from tableA
where ID not exists (select 'x' from tableB
where tableB.ID = tableA.ID);
HTH
"Jason John" <jason_jb_at_utas.edu.au> wrote in message
news:990145812.701684_at_atlas.corp.au.home.com...
> Can anyone help me convert the following SQL into PL/SQL ...
>
> delete from tableA where ID not in (select ID from tableB);
>
> ... so that the stuff in brackets () is decided only once (i.e.: we don't
do
> a select for every row in tableA).
>
>
> thanks :)
> Jason
>
>
>
Received on Fri May 18 2001 - 22:56:05 CEST