ALL_UPDATABLE_COLUMNS describes all columns in a join view that are updatable by the current user, subject to appropriate privileges.
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(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 |