possible in PL/SQL (and any other language). That way, you give the compiler maximum freedom to optimization. -- Create Driver for Test I generate 100,000 rows for my cursor using by CONNECT BY LEVEL ...
-- Description: A free-standing SQL wrapper over DBMS_XPLAN. Provides access to the -- DBMS_XPLAN.DISPLAY_CURSOR pipelined function for a given SQL_ID and CHILD_NO. -- The XPLAN utility has one ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results