Query dba_updatable_columns : dba_updatable_columns « System Tables Views « Oracle PL / SQL






Query dba_updatable_columns

 
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> --

 








Related examples in the same category