VIEW: SYS.USER_UPDATABLE_COLUMNS

Source

View Text - Preformatted

select u.name, o.name, c.name,
      decode(bitand(c.fixedstorage,2),
             2,
             case when
               exists
                 (select 1 from trigger$ t, "_CURRENT_EDITION_OBJ" trigobj
                  where     t.obj# = trigobj.obj#  /* trigger in edition */
                        and t.type# = 4            /* and insted of trigger */
                        and t.enabled = 1          /* and enabled */
                        and t.baseobject = o.obj#  /* on selected object */
                        and t.update$ <> 0)        /* triggers on update */
               then
                 'YES'
               else
                 'NO'
             end,
             decode(bitand(c.property,4096),4096,'NO','YES')),
      decode(bitand(c.fixedstorage,2),
             2,
             case when
               exists
                 (select 1 from trigger$ t, "_CURRENT_EDITION_OBJ" trigobj
                  where     t.obj# = trigobj.obj#  /* trigger in edition */
                        and t.type# = 4            /* and insted of trigger */
                        and t.enabled = 1          /* and enabled */
                        and t.baseobject = o.obj#  /* on selected object */
                        and t.insert$ <> 0)        /* triggers on insert */
               then
                 'YES'
               else
                 'NO'
             end,
             decode(bitand(c.property,2048),2048,'NO','YES')),
      decode(bitand(c.fixedstorage,2),
             2,
             case when
               exists
                 (select 1 from trigger$ t, "_CURRENT_EDITION_OBJ" trigobj
                  where     t.obj# = trigobj.obj#  /* trigger in edition */
                        and t.type# = 4            /* and insted of trigger */
                        and t.enabled = 1          /* and enabled */
                        and t.baseobject = o.obj#  /* on selected object */
                        and t.delete$ <> 0)        /* triggers on delete */
               then
                 'YES'
               else
                 'NO'
             end,
             decode(bitand(c.property,8192),8192,'NO','YES'))
from sys."_CURRENT_EDITION_OBJ" o, sys.user$ u, sys.col$ c
where u.user# = o.owner#
  and c.obj#  = o.obj#
  and u.user# = userenv('SCHEMAID')
  and bitand(c.property, 32) = 0 /* not hidden column */

View Text - HTML Formatted

SELECT U.NAME
, O.NAME
, C.NAME
, DECODE(BITAND(C.FIXEDSTORAGE
, 2)
, 2
, CASE WHEN EXISTS (SELECT 1
FROM TRIGGER$ T
, "_CURRENT_EDITION_OBJ" TRIGOBJ
WHERE T.OBJ# = TRIGOBJ.OBJ# /* TRIGGER IN EDITION */
AND T.TYPE# = 4 /*
AND INSTED OF TRIGGER */
AND T.ENABLED = 1 /*
AND ENABLED */
AND T.BASEOBJECT = O.OBJ# /* ON SELECTED OBJECT */
AND T.UPDATE$ <> 0) /* TRIGGERS ON UPDATE */ THEN 'YES' ELSE 'NO' END
, DECODE(BITAND(C.PROPERTY
, 4096)
, 4096
, 'NO'
, 'YES'))
, DECODE(BITAND(C.FIXEDSTORAGE
, 2)
, 2
, CASE WHEN EXISTS (SELECT 1
FROM TRIGGER$ T
, "_CURRENT_EDITION_OBJ" TRIGOBJ
WHERE T.OBJ# = TRIGOBJ.OBJ# /* TRIGGER IN EDITION */
AND T.TYPE# = 4 /*
AND INSTED OF TRIGGER */
AND T.ENABLED = 1 /*
AND ENABLED */
AND T.BASEOBJECT = O.OBJ# /* ON SELECTED OBJECT */
AND T.INSERT$ <> 0) /* TRIGGERS ON INSERT */ THEN 'YES' ELSE 'NO' END
, DECODE(BITAND(C.PROPERTY
, 2048)
, 2048
, 'NO'
, 'YES'))
, DECODE(BITAND(C.FIXEDSTORAGE
, 2)
, 2
, CASE WHEN EXISTS (SELECT 1
FROM TRIGGER$ T
, "_CURRENT_EDITION_OBJ" TRIGOBJ
WHERE T.OBJ# = TRIGOBJ.OBJ# /* TRIGGER IN EDITION */
AND T.TYPE# = 4 /*
AND INSTED OF TRIGGER */
AND T.ENABLED = 1 /*
AND ENABLED */
AND T.BASEOBJECT = O.OBJ# /* ON SELECTED OBJECT */
AND T.DELETE$ <> 0) /* TRIGGERS ON DELETE */ THEN 'YES' ELSE 'NO' END
, DECODE(BITAND(C.PROPERTY
, 8192)
, 8192
, 'NO'
, 'YES')) FROM SYS."_CURRENT_EDITION_OBJ" O
, SYS.USER$ U
, SYS.COL$ C WHERE U.USER# = O.OWNER#
AND C.OBJ# = O.OBJ#
AND U.USER# = USERENV('SCHEMAID')
AND BITAND(C.PROPERTY
, 32) = 0 /* NOT HIDDEN COLUMN */