ALL_UPDATABLE_COLUMNS

ALL_UPDATABLE_COLUMNS describes all columns in a join view that are updatable by the current user, subject to appropriate privileges.

Column Datatype NULL Description
OWNER VARCHAR2(128) NOT NULL Owner of the table
TABLE_NAME VARCHAR2(128) NOT NULL Name of the table
COLUMN_NAME VARCHAR2(128) NOT NULL Column name
UPDATABLE VARCHAR2(3)   Indicates whether the column is updatable (YES) or not (NO)Foot 1
INSERTABLE VARCHAR2(3)   Indicates whether the column is insertable (YES) or not (NO)
DELETABLE VARCHAR2(3)   Indicates whether the column is deletable (YES) or not (NO)

Footnote 1 Starting with Oracle Database 21c, there is a circumstance under which a column is updatable even if its UPDATABLE value is NO in this view. A column with a NO value can be updated if it is in a non-key-preserved table, the UPDATE operation updates only columns in that table, and the update is deterministic, that is, it updates each row only once. See Oracle AI Database Concepts for more information.

Note: The values shown in the UPDATABLE, INSERTABLE, and DELETABLE columns are not instantly updated when a DDL operation that would affect these attributes occurs on one of the tables referenced in the FROM clause of the view definition. For example, these columns are not instantly updated when a primary key or unique constraint is added to or removed from the non-key-preserved table. To remedy this situation, recompile the view using the ALTER VIEW COMPILE statement to ensure that the latest information is displayed.

See Also: