ALL_UPDATABLE_COLUMNS
describes all columns in a join view that are updatable by the current user, subject to appropriate privileges.
Related Views
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 of the table |
|
|
|
Name of the table |
|
|
|
Column name |
|
|
Indicates whether the column is updatable ( |
|
|
|
Indicates whether the column is insertable ( |
|
|
|
Indicates whether the column is deletable ( |
See Also:
Oracle Database Concepts for information on updatable join views