VIEW: SYS.ALL_USERS

Source

View Text - Preformatted

select u.name, u.user#, u.ctime,
       decode(bitand(u.spare1, 128), 128, 'YES', 'NO'),
       decode(bitand(u.spare1, 256), 256, 'Y', 'N')
from sys.user$ u, sys.ts$ dts, sys.ts$ tts
where u.datats# = dts.ts#
  and u.tempts# = tts.ts#
  and u.type# = 1

View Text - HTML Formatted

SELECT U.NAME
, U.USER#
, U.CTIME
, DECODE(BITAND(U.SPARE1
, 128)
, 128
, 'YES'
, 'NO')
, DECODE(BITAND(U.SPARE1
, 256)
, 256
, 'Y'
, 'N') FROM SYS.USER$ U
, SYS.TS$ DTS
, SYS.TS$ TTS WHERE U.DATATS# = DTS.TS#
AND U.TEMPTS# = TTS.TS#
AND U.TYPE# = 1