ALL_UPDATABLE_COLUMNS

Previous Next JavaScript must be enabled to correctly display this content

3.133 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`)
`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`)

See Also:

"DBA_UPDATABLE_COLUMNS"
"USER_UPDATABLE_COLUMNS"
Oracle Database Concepts for information on updatable join views