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 |
Owner of the table |
TABLE_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the table |
COLUMN_NAME |
VARCHAR2(30) |
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) |