Oracle Views

A stacked view is not the base view for the window to which it is Assigned. However, content view is the base view and this is how it differs from the stacked view...
There are three types of canvas views:- 1.Stacked Canvas Views 2.Content Canvas Views....
Subquery is SELECT statement (cannot contain the ORDER BY clause)...
Using Views, user’s access to the entire content of table can be restricted by allowing accessing only Views with only required columns of the table.....
The view’s column names are same as the table’s column name. New column names has to be explicitly listed in the CREATE View......