Create a view that will display name, department number, and total income (salary+commission) of each employee in department 10. Prevent change of department through the view.

Question

Use case study databases for the following queries.

Answer 1

```
SQL> CREATE OR REPLACE VIEW EMP_TOTSAL_VU
2 AS
3 SELECT LNAME, FNAME, SALARY+NVL(COMMISSION,0) TOTSAL
4 FROM EMPLOYEE
5 WHERE DEPTID=10
6 WITH CHECK OPTION;

VIEW CREATED.
```