pl/sql
From: Jason John <jason_jb_at_utas.edu.au>
Date: Fri, 18 May 2001 00:30:12 GMT
Message-ID: <990145812.701684_at_atlas.corp.au.home.com>
Date: Fri, 18 May 2001 00:30:12 GMT
Message-ID: <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 - 02:30:12 CEST