ALL_UPDATABLE

4.155 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 1Starting 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.