Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-04 |
|
|
PDF · Mobi · ePub |
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 |