| |
 |
|
DBA_UPDATABLE_COLUMNS view tips
Oracle Tips by Burleson Consulting |
DBA_UPDATABLE_COLUMNS
<< Return to the index
Oracle 11g makes the following comments about the DBA_UPDATABLE_COLUMNS table: "Description of dba updatable columns"
Related notes on DBA_UPDATABLE_COLUMNS:
Column description of the DBA_UPDATABLE_COLUMNS view:OWNERDescription of DBA_UPDATABLE_COLUMNS.OWNER: "table owner" TABLE_NAMEDescription of DBA_UPDATABLE_COLUMNS.TABLE_NAME: "table name" COLUMN_NAMEDescription of DBA_UPDATABLE_COLUMNS.COLUMN_NAME: "column name" UPDATABLEDescription of DBA_UPDATABLE_COLUMNS.UPDATABLE: "Is the column updatable?" INSERTABLEDescription of DBA_UPDATABLE_COLUMNS.INSERTABLE: "Is the column insertable?" DELETABLEDescription of DBA_UPDATABLE_COLUMNS.DELETABLE: "Is the column deletable?"
DBA_UPDATABLE_COLUMNS View SourceOracle 11g's data dictionary defines the DBA_UPDATABLE_COLUMNS view using the following source query:
select u.name, o.name, c.name,
decode(bitand(c.fixedstorage,2),
2, decode(bitand(v.flags,8192), 8192, 'YES', 'NO'),
decode(bitand(c.property,4096),4096,'NO','YES')),
decode(bitand(c.fixedstorage,2),
2, decode(bitand(v.flags,4096), 4096, 'YES', 'NO'),
decode(bitand(c.property,2048),2048,'NO','YES')),
decode(bitand(c.fixedstorage,2),
2, decode(bitand(v.flags,16384), 16384, 'YES', 'NO'),
decode(bitand(c.property,8192),8192,'NO','YES'))
from sys."_CURRENT_EDITION_OBJ" o, sys.user$ u, sys.col$ c, sys.view$ v
where u.user# = o.owner#
and c.obj# = o.obj#
and c.obj# = v.obj#(+)
and bitand(c.property, 32) = 0 /* not hidden column */
 |
If you like Oracle tuning, see the book "Oracle
Tuning: The Definitive Reference", with 950 pages of tuning tips and
scripts.
You can buy it direct from the publisher for 30%-off and get
instant access to the code depot of Oracle tuning scripts. |
 |
 |
|
Download your Oracle scripts now:
www.oracle-script.com
The
definitive Oracle Script collection for every Oracle professional DBA
|
|
