Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Using EXISTS - Queries NOT co-related
On Jun 1, 1:02 pm, "sims" <s..._at_mailinator.com> wrote:
> 10gR2
>
> Can I use EXISTS to replace code like this:
> -------------------------------------------------------
> SELECT count(*)
> INTO l_count
> FROM scott.salgrade WHERE grade > 5 ;
>
> IF l_count > 0 THEN
> INSERT INTO scott.emp SELECT...<snip>;
> END IF;
>
> ---- With code like this ---------------------------------
>
> INSERT INTO scott.emp SELECT...<snip>
> WHERE EXISTS (SELECT null
> FROM scott.salgrade WHERE grade > 5);
>
> -----------------------------------------------------------
>
> Note the 2 queries are not "co-related" but are independent
>
> thanks
Did you try it?
What were your results?
Coding is probably better if you switch it to WHERE EXISTS ( SELECT 1 ... instead of SELECT NULL Received on Fri Jun 01 2007 - 12:29:52 CDT
![]() |
![]() |