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