ALL_UPDATABLE_COLUMNS

ALL_UPDATABLE_COLUMNS describes all columns in a join view that are updatable by the current user.

Related views:

• DBA_UPDATABLE_COLUMNS describes all columns in a join view that are updatable by the database administrator.

• USER_UPDATABLE_COLUMNS describes all columns owned by the current user that are in a join view and are updatable by the current user.

  Column	Datatype	NULL	Description
  OWNER	VARCHAR2(30)	NOT NULL	Table owner
  TABLE_NAME	VARCHAR2(30)	NOT NULL	Table name
  COLUMN_NAME	VARCHAR2(30)	NOT NULL	Column name
  UPDATABLE	VARCHAR2(3)		Indicates whether the column is updatable
  INSERTABLE	VARCHAR2(3)		Indicates whether the column is insertable
  DELETABLE	VARCHAR2(3)		Indicates whether the column is deletable