Simple View :
Derives data from only one table.
Contains no functions or group of data
Can perform DML operations through the view.
Complex View :
* Derives data from many tables. Contain functions or groups of data.
* Derives data from many tables. Contain functions or groups of data.
* Does not always allow DML operations through the view
