Read-Only Views:

Several Views can be created for selection purpose alone. In which view will not permits a user or the owner of the view to perform any DML operation. The example shows this view: CREATE OR REPLACE VIEW read_view AS

SELECT * FROM dept WITH READ ONLY;

View created.

INSERT INTO read_view VALUES (60,'Purchase','Texas');

INSERT INTO read_view VALUES (60,'Purchase','Texas')

*

ERROR at line 1:

ORA-01733: virtual column not permitted here