VIEW: SYS.EXU8ORDOP

Source

View Text - Preformatted

SELECT                                              /*+ no_filtering */
                MAX(level), d1.d_obj#, d1.owner#
        FROM    (
                    SELECT                                      /*+ no_merge */
                            d.d_obj#, d.p_obj#, v.owner#
                    FROM    sys.dependency$ d,
                    (select obj#, owner# from sys.obj$ where type#=33) v
                    WHERE   v.obj# = d.d_obj#) d1
        CONNECT BY PRIOR d1.d_obj# = d1.p_obj#
        GROUP BY d1.d_obj#, d1.owner#

View Text - HTML Formatted

SELECT /*+ NO_FILTERING */ MAX(LEVEL)
, D1.D_OBJ#
, D1.OWNER#
FROM ( SELECT /*+ NO_MERGE */ D.D_OBJ#
, D.P_OBJ#
, V.OWNER#
FROM SYS.DEPENDENCY$ D
, (SELECT OBJ#
, OWNER#
FROM SYS.OBJ$
WHERE TYPE#=33) V
WHERE V.OBJ# = D.D_OBJ#) D1 CONNECT BY PRIOR D1.D_OBJ# = D1.P_OBJ# GROUP BY D1.D_OBJ#
, D1.OWNER#