VIEW: SYS.USER_PLSQL_TYPES

Source

View Text - Preformatted

select t.typ_name ||
        decode(bitand(t.properties,134217728),134217728,
                      '%ROWTYPE', null),
       o.name, t.toid,
       decode(t.typecode, 250,
                          decode(bitand(t.properties,134217728),134217728,
                          'CURSOR ROWTYPE', 'PL/SQL RECORD'),
                          122, 'COLLECTION',
                          'UNKNOWN TYPECODE: ' || t.typecode),
       t.attributes,
       decode(bitand(t.properties, 67108864), 67108864, 'YES', 0, 'NO')
from sys.type$ t, sys."_CURRENT_EDITION_OBJ" o
where o.owner# = userenv('SCHEMAID')                   -- only the current user
  and t.package_obj# IS NOT NULL                          -- only package types
  and o.obj# = t.package_obj#                 -- match type to its package obj#
  and o.type# <> 10                              -- package must not be invalid

View Text - HTML Formatted

SELECT T.TYP_NAME || DECODE(BITAND(T.PROPERTIES
, 134217728)
, 134217728
, '%ROWTYPE'
, NULL)
, O.NAME
, T.TOID
, DECODE(T.TYPECODE
, 250
, DECODE(BITAND(T.PROPERTIES
, 134217728)
, 134217728
, 'CURSOR ROWTYPE'
, 'PL/SQL RECORD')
, 122
, 'COLLECTION'
, 'UNKNOWN TYPECODE: ' || T.TYPECODE)
, T.ATTRIBUTES
, DECODE(BITAND(T.PROPERTIES
, 67108864)
, 67108864
, 'YES'
, 0
, 'NO') FROM SYS.TYPE$ T
, SYS."_CURRENT_EDITION_OBJ" O WHERE O.OWNER# = USERENV('SCHEMAID') -- ONLY THE CURRENT USER
AND T.PACKAGE_OBJ# IS NOT NULL -- ONLY PACKAGE TYPES
AND O.OBJ# = T.PACKAGE_OBJ# -- MATCH TYPE TO ITS PACKAGE OBJ#
AND O.TYPE# <> 10 -- PACKAGE MUST NOT BE INVALID