Oracle PL/SQL/System Tables Views/dba updatable columns

Query dba_updatable_columns

   <source lang="sql">

SQL> SQL> set echo off SQL> set verify off SQL> set linesize 72 SQL> set pagesize 9999 SQL> set feedback on SQL> SQL> column view_name format a30 SQL> column column_name format a30 SQL> column i format a1 SQL> column u format a1 SQL> column d format a1 SQL> SQL> clear breaks breaks cleared SQL> break on view_name SQL> SQL> select table_name view_name,

 2         column_name,
 3         decode( insertable, "YES", null, "*" ) i,
 4         decode( updatable, "YES", null, "*" ) u,
 5         decode( deletable, "YES", null, "*" ) d
 6    from dba_updatable_columns
 7   where rownum < 50
 8  /

VIEW_NAME Column Name I U D

---

------------------------------ - - -

ICOL$ OBJ#

                              BO#
                              COL#
                              POS#
                              SEGCOL#
                              SEGCOLLENGTH
                              OFFSET
                              INTCOL#
                              SPARE1
                              SPARE2
                              SPARE3
                              SPARE4
                              SPARE5
                              SPARE6

CON$ OWNER#

                              NAME
                              CON#
                              SPARE1
                              SPARE2
                              SPARE3
                              SPARE4
                              SPARE5
                              SPARE6

UNDO$ US#

                              NAME
                              USER#
                              FILE#
                              BLOCK#
                              SCNBAS
                              SCNWRP
                              XACTSQN
                              UNDOSQN
                              INST#
                              STATUS$
                              TS#
                              UGRP#
                              KEEP
                              OPTIMAL
                              FLAGS
                              SPARE1
                              SPARE2
                              SPARE3
                              SPARE4
                              SPARE5
                              SPARE6

C_COBJ# OBJ# PROXY_ROLE_DATA$ CLIENT#

                              PROXY#
                              ROLE#

49 rows selected. SQL> SQL> prompt SQL> prompt "*" indicated action not permitted. "*" indicated action not permitted. SQL> prompt SQL> SQL> --

</source>