Compare SQL Server, Oracle, and DB2 view creation statements.

A view can be simply considered as an alias for a query:

It can restrict data access and simplify queries.

The statements for creating a view are as follows:

 

SQL Server:

Create view empv20 as select * from EMP where deptno = 20; Modify View: Alter view empv20 As select ename From EMP Where deptno = 20;

The statements created on Oracle and DB2 are identical.

• Create or replace view empvu20 • as select * • from EMP • where deptno = 20 you can also add the with check option to protect view integrity: Create or replace view empvu20 As select * From EMP Where deptno = 20 With check option constraint empvu20_ck;

SQL> Update empvu20 Set deptno = 10 Where e-mapreduce = 7788;Update empvu20 * error at line 1: ORA-01402: view with check option where-clause Violation