DBA Data[Home] [Help]

VIEW: SYS.KU$_CHILD_NESTED_TAB_VIEW

Source

View Text - Preformatted

SELECT  u.name, op.name, ont.name, t.property
        FROM    sys.obj$ ont, sys.obj$ op, sys.user$ u, sys.ntab$ n, sys.tab$ t
        WHERE   op.owner# = u.user# AND n.obj# = op.obj# AND
                n.ntab# = ont.obj# AND t.obj# = ont.obj#
View Text - HTML Formatted

SELECT U.NAME
, OP.NAME
, ONT.NAME
, T.PROPERTY
FROM SYS.OBJ$ ONT
, SYS.OBJ$ OP
, SYS.USER$ U
, SYS.NTAB$ N
, SYS.TAB$ T
WHERE OP.OWNER# = U.USER#
AND N.OBJ# = OP.OBJ# AND N.NTAB# = ONT.OBJ#
AND T.OBJ# = ONT.OBJ#