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, 6: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
Yes, looks good. I don't like that COUNT(*) without even an AND ROWNUM = 1. Received on Sat Jun 02 2007 - 05:02:54 CDT
![]() |
![]() |