Database Reference
In-Depth Information
The data dictionary table USER_UPDATABLE_COLUMNS lists
each view and its columns, specifying whether the column can be refer-
enced when updating, inserting, or deleting through the view. Execute
this query to see which views are updatable, including their respective
changeable columns. The query is shown in Figure 19.9, including the
page size altered to show the CONSTRAINT_USARTISTS view and
headings in the same image.
COLUMN COLUMN_NAME FORMAT A20
SELECT TABLE_NAME, COLUMN_NAME, UPDATABLE, INSERTABLE
, DELETABLE
FROM USER_UPDATABLE_COLUMNS U
WHERE EXISTS (SELECT VIEW_NAME FROM USER_VIEWS V
WHERE U.TABLE_NAME = V.VIEW_NAME)
ORDER BY 1, 2;
Note:
The complete syntax of the INSERT, UPDATE, and DELETE com-
mands can be found in Chapter 15. The same syntax applies to both views
and tables.
Figure 19.9
The
CONSTRAINT_
USARTISTS View
Can Be Updated,
Inserted into, and
Deleted from.
