Different types of canvas views

Explain the different types of canvas views.

Different types of Canvas views:-

Stacked Canvas Views - A view that is displayed on top of the content canvas of the same window.

Content Canvas Views - This is the main view that occupies the entire window pane.

Horizontal/Vertical Toolbar Canvas Views - Tool bars fall under this category of canvas views that may be displayed vertically or horizontally.
Significance of OR REPLACE, FORCE and NOFORCE while creating view
Subquery is SELECT statement (cannot contain the ORDER BY clause)...
List out advantages of Views
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.....
List out the guidelines to create a View
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......
Post your comment