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;

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