SELECT a$.owner, u$.user#, a$.name, o$.obj#, a$.callorder, a$.callarg,
a$.obj_type, a$.user_arg, t$.property
FROM sys.expact$ a$, sys.user$ u$, sys.obj$ o$, sys.tab$ t$
WHERE u$.name = a$.owner AND
o$.owner# = u$.user# AND
o$.name = a$.name AND
t$.obj# = o$.obj#
SELECT A$.OWNER
, U$.USER#
, A$.NAME
, O$.OBJ#
, A$.CALLORDER
, A$.CALLARG
,
A$.OBJ_TYPE
, A$.USER_ARG
, T$.PROPERTY
FROM SYS.EXPACT$ A$
, SYS.USER$ U$
, SYS.OBJ$ O$
, SYS.TAB$ T$
WHERE U$.NAME = A$.OWNER AND
O$.OWNER# = U$.USER# AND
O$.NAME = A$.NAME AND
T$.OBJ# = O$.OBJ#
|
|
|