under the covers of a function

From: imc <icohen33_at_gmail.com>
Date: 14 Jul 2005 07:23:52 -0700
Message-ID: <1121351032.495172.33350@g49g2000cwa.googlegroups.com>

I read somewhere that a certain oracle supplied function does the following under the covers but can not remember which function.

FOR x IN ( SELECT *

           FROM DUAL
           WHERE EXISTS ( SELECT NULL
                          FROM   XML_TREE_STAGING
                          WHERE  parent_id = p_company_id)) LOOP

  RETURN TRUE;
END LOOP; Oracle 9i on WinDOZ.

Thanks
IMC Received on Thu Jul 14 2005 - 09:23:52 CDT