VIEW: SYS.ALL_VIEWS_AE

Source

View Text - Preformatted

select u.name, o.name, v.textlength, v.text, t.typetextlength, t.typetext,
       t.oidtextlength, t.oidtext, t.typeowner, t.typename,
       decode(bitand(v.property, 134217728), 134217728,
              (select sv.name from superobj$ h, obj$ sv
              where h.subobj# = o.obj# and h.superobj# = sv.obj#), null),
       decode(bitand(v.property, 32), 32, 'Y', 'N'),
       decode(bitand(v.property, 16384), 16384, 'Y', 'N'),
       o.defining_edition,
       decode(bitand(v.property/4294967296, 134217728), 134217728, 'Y', 'N'),
       decode(bitand(o.flags,8),8,'CURRENT_USER','DEFINER')
from sys."_ACTUAL_EDITION_OBJ" o, sys.view$ v, sys.user$ u, sys.typed_view$ t
where o.obj# = v.obj#
  and o.obj# = t.obj#(+)
  and o.owner# = u.user#
  and (o.owner# = userenv('SCHEMAID')
       or o.obj# in
            (select oa.obj#
             from sys.objauth$ oa
             where oa.grantee# in ( select kzsrorol
                                         from x$kzsro
                                  )
            )
        or /* user has system privileges */
          exists (select null from v$enabledprivs
                  where priv_number in (-45 /* LOCK ANY TABLE */,
                                        -47 /* SELECT ANY TABLE */,
                                        -397/* READ ANY TABLE */,
                                        -48 /* INSERT ANY TABLE */,
                                        -49 /* UPDATE ANY TABLE */,
                                        -50 /* DELETE ANY TABLE */)
                  )
      )

View Text - HTML Formatted

SELECT U.NAME
, O.NAME
, V.TEXTLENGTH
, V.TEXT
, T.TYPETEXTLENGTH
, T.TYPETEXT
, T.OIDTEXTLENGTH
, T.OIDTEXT
, T.TYPEOWNER
, T.TYPENAME
, DECODE(BITAND(V.PROPERTY
, 134217728)
, 134217728
, (SELECT SV.NAME
FROM SUPEROBJ$ H
, OBJ$ SV
WHERE H.SUBOBJ# = O.OBJ#
AND H.SUPEROBJ# = SV.OBJ#)
, NULL)
, DECODE(BITAND(V.PROPERTY
, 32)
, 32
, 'Y'
, 'N')
, DECODE(BITAND(V.PROPERTY
, 16384)
, 16384
, 'Y'
, 'N')
, O.DEFINING_EDITION
, DECODE(BITAND(V.PROPERTY/4294967296
, 134217728)
, 134217728
, 'Y'
, 'N')
, DECODE(BITAND(O.FLAGS
, 8)
, 8
, 'CURRENT_USER'
, 'DEFINER') FROM SYS."_ACTUAL_EDITION_OBJ" O
, SYS.VIEW$ V
, SYS.USER$ U
, SYS.TYPED_VIEW$ T WHERE O.OBJ# = V.OBJ#
AND O.OBJ# = T.OBJ#(+)
AND O.OWNER# = U.USER#
AND (O.OWNER# = USERENV('SCHEMAID') OR O.OBJ# IN (SELECT OA.OBJ#
FROM SYS.OBJAUTH$ OA
WHERE OA.GRANTEE# IN ( SELECT KZSROROL
FROM X$KZSRO ) ) OR /* USER HAS SYSTEM PRIVILEGES */ EXISTS (SELECT NULL
FROM V$ENABLEDPRIVS
WHERE PRIV_NUMBER IN (-45 /* LOCK ANY TABLE */
, -47 /* SELECT ANY TABLE */
, -397/* READ ANY TABLE */
, -48 /* INSERT ANY TABLE */
, -49 /* UPDATE ANY TABLE */
, -50 /* DELETE ANY TABLE */) ) )