VIEW: SYS.EXU7ORDU

Source

View Text - Preformatted

SELECT MAX(LEVEL), d_obj# from sys.dependency$
       WHERE d_owner# = uid
       CONNECT BY PRIOR d_obj# = p_obj#
       GROUP BY d_obj#, d_owner#

View Text - HTML Formatted

SELECT MAX(LEVEL)
, D_OBJ#
FROM SYS.DEPENDENCY$
WHERE D_OWNER# = UID CONNECT BY PRIOR D_OBJ# = P_OBJ# GROUP BY D_OBJ#
, D_OWNER#