“It is easier to go down a hill than up it, but the view is much better at the top.”
Creating a Simple View
|CREATE View Employee_V AS|
|FROM Employee_Table ;|
The purposes of views are to restrict access to certain columns, derive columns or Join Tables, and to restrict access to certain rows (if a WHERE clause is used).
Basic Rules for Views
|CREATE View Department_Salaries ...|