Hi,
CREATE [OR REPLACE] [FORCE|NOFORCE] VIEW view name [alias[, alias]�)] AS subquery [WITH CHECK OPTION [CONSTRAINT constraint] ] [WITH READ ONLY]

You can ensure that no DML operations occur by adding the WITH READ ONLY option to your view definition.
Example:
SQL> CREATE OR REPLACE VIEW myview2
AS SELECT empno, ename, sal
FROM emp
WHERE deptno=10 WITH READ ONLY OPTION;

Any attempt to perform DML on any row in the view results in an Oracle server error: ORA-01725

Regards,
Rohit Nirkhe,oracle/apps DBA,OCP 8i,9i
[email protected]