VIEW: SYS.EXU9TYP

Source

View Text - Preformatted

SELECT  o.name, u.name, o.owner#, t.toid,
                TO_CHAR(o.mtime, 'YYYY-MM-DD:HH24:MI:SS'), o.obj#, tm.audit$,
                DECODE(BITAND(o.flags, 16), 16, 1, 0), sv.sql_version,
                o.status, t.version#, t.hashcode, t.typeid,
                NVL(t.roottoid,HEXTORAW('00'))
        FROM    sys.obj$ o, sys.user$ u, sys.type$ t, sys.type_misc$ tm,
                sys.exu816sqv sv
        WHERE   o.type# = 13 AND
                o.oid$ = t.toid AND
                u.user# = o.owner# AND
                tm.obj# = o.obj# AND
                t.toid  = t.tvoid AND                 /* Only the latest rev */
                BITAND(t.properties, 2128) = 0 AND /* skip system gen'd types*/
                u.name NOT IN ('ORDSYS', 'MDSYS', 'CTXSYS', 'ORDPLUGINS',
                               'LBACSYS', 'XDB', 'SI_INFORMTN_SCHEMA',
                               'DIP', 'DBSNMP', 'EXFSYS', 'WMSYS','ORACLE_OCM',
                               'ANONYMOUS', 'XS$NULL', 'APPQOSSYS',
                               'OJVMSYS', 'SYSBACKUP', 'SYSDG', 'SYSKM',
                               'DVSYS', 'DVF', 'DBHADOOP', 'ORDDATA',
                               'GSMADMIN_INTERNAL', 'GSMUSER', 'GSMCATUSER',
                               'LOGSTDBY_ADMINISTRATOR','OLAPSYS','FLOWS_FILES',
                               'APEX_040200') AND
                o.spare1 = sv.version# (+)

View Text - HTML Formatted

SELECT O.NAME
, U.NAME
, O.OWNER#
, T.TOID
, TO_CHAR(O.MTIME
, 'YYYY-MM-DD:HH24:MI:SS')
, O.OBJ#
, TM.AUDIT$
, DECODE(BITAND(O.FLAGS
, 16)
, 16
, 1
, 0)
, SV.SQL_VERSION
, O.STATUS
, T.VERSION#
, T.HASHCODE
, T.TYPEID
, NVL(T.ROOTTOID
, HEXTORAW('00'))
FROM SYS.OBJ$ O
, SYS.USER$ U
, SYS.TYPE$ T
, SYS.TYPE_MISC$ TM
, SYS.EXU816SQV SV
WHERE O.TYPE# = 13 AND O.OID$ = T.TOID AND U.USER# = O.OWNER# AND TM.OBJ# = O.OBJ# AND T.TOID = T.TVOID
AND /* ONLY THE LATEST REV */ BITAND(T.PROPERTIES
, 2128) = 0
AND /* SKIP SYSTEM GEN'D TYPES*/ U.NAME NOT IN ('ORDSYS'
, 'MDSYS'
, 'CTXSYS'
, 'ORDPLUGINS'
, 'LBACSYS'
, 'XDB'
, 'SI_INFORMTN_SCHEMA'
, 'DIP'
, 'DBSNMP'
, 'EXFSYS'
, 'WMSYS'
, 'ORACLE_OCM'
, 'ANONYMOUS'
, 'XS$NULL'
, 'APPQOSSYS'
, 'OJVMSYS'
, 'SYSBACKUP'
, 'SYSDG'
, 'SYSKM'
, 'DVSYS'
, 'DVF'
, 'DBHADOOP'
, 'ORDDATA'
, 'GSMADMIN_INTERNAL'
, 'GSMUSER'
, 'GSMCATUSER'
, 'LOGSTDBY_ADMINISTRATOR'
, 'OLAPSYS'
, 'FLOWS_FILES'
, 'APEX_040200') AND O.SPARE1 = SV.VERSION# (+)