VIEW: SYS.EXU7USCU

Source

View Text - Preformatted

SELECT o$.obj#, o$.name,
               i$.ts# * 4096 + i$.file#,
               i$.block#, i$.bo#, t$.name, 
               i$.pctfree$, i$.initrans, i$.maxtrans
	from sys.exu7obj o$, sys.ind$ i$, sys.file$ f$, sys.ts$ t$
	where o$.obj# = i$.obj# and bitand(i$.property,1)=1 
        and f$.file#=i$.file# and f$.ts# = t$.ts#

View Text - HTML Formatted

SELECT O$.OBJ#
, O$.NAME
, I$.TS# * 4096 + I$.FILE#
, I$.BLOCK#
, I$.BO#
, T$.NAME
, I$.PCTFREE$
, I$.INITRANS
, I$.MAXTRANS FROM SYS.EXU7OBJ O$
, SYS.IND$ I$
, SYS.FILE$ F$
, SYS.TS$ T$ WHERE O$.OBJ# = I$.OBJ#
AND BITAND(I$.PROPERTY
, 1)=1
AND F$.FILE#=I$.FILE#
AND F$.TS# = T$.TS#