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