Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Using EXISTS - Queries NOT co-related

Re: Using EXISTS - Queries NOT co-related

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: Fri, 01 Jun 2007 10:29:52 -0700
Message-ID: <1180718992.392900.190350@q66g2000hsg.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US