Re: pl/sql

From: Alex Filonov <afilonov_at_pro-ns.net>
Date: Tue, 22 May 2001 02:12:03 GMT
Message-ID: <3B09CAF2.8BDF0969_at_pro-ns.net>


Jason John wrote:

> 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

If you run explain plan on your query, you can see that select statement in brackets is executed only once! You don't need to convert statement into PL/SQL, it'll run faster as is. Received on Tue May 22 2001 - 04:12:03 CEST

Original text of this message