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#
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#
|
|
|