DBA Data[Home] [Help]

VIEW: SYS.EXU8PST

Source

View Text - Preformatted

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#
View Text - HTML Formatted

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#