Type of views:
Simple views and Difficult Views
|
Feature
|
Simple Views
|
Complex Views
|
|
Number of tables
|
One
|
One or more
|
|
Contain Functions
|
No
|
Yes
|
|
Contain groups of data
|
No
|
Yes
|
|
Data Manipulation
|
IS allowed
|
Not always
|
Let us look into some of the examples. To see all the details about existing views in
Oracle:
SELECT* FROM USER_VIEWS;