"Be the change that you want to see in the world."
A view is a virtual table.
A view may define a subset of columns
A view can even define a subset of rows if it has a WHERE clause
A view never duplicates data or stores the data separately
View definitions are stored in the Data Dictionary, not the user’s space Views provide security
An additional level of security is provided.
Helps the business user not miss join conditions.
Help control read and update privileges.
Unaffected when new columns are added to a table.
Unaffected when a column is dropped unless its referenced in the view.
Only utilities, such as FastLoad, ...