| Oracle® Database Reference 10g Release 1 (10.1) Part Number B10755-01 |
|
|
View PDF |
| Oracle® Database Reference 10g Release 1 (10.1) Part Number B10755-01 |
|
|
View PDF |
ALL_UPDATABLE_COLUMNS describes all columns in a join view that are updatable by the current user.
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 |
|
 Copyright © 2002, 2003, Oracle Corporation All Rights Reserved. |
|
