4.136 ALL_UPDATABLE_COLUMNS

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

Related Views

  • DBA_UPDATABLE_COLUMNS describes all columns in a join view that are updatable by the database administrator, subject to appropriate privileges.

  • USER_UPDATABLE_COLUMNS describes all columns owned by the current user that are in a join view and 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 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: