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 -> Using EXISTS - Queries NOT co-related

Using EXISTS - Queries NOT co-related

From: sims <sims_at_mailinator.com>
Date: Fri, 1 Jun 2007 13:02:04 -0400
Message-ID: <1360k8i3jpkuve3@corp.supernews.com>


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;

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 Received on Fri Jun 01 2007 - 12:02:04 CDT

Original text of this message

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