1. View is nothing but parsed SQL statement which fetches record at the time of execution.

2.There are mainly two type of views

a) Simple View

b) Complex View

apart from that we can also subdivided views as UpdatableViews and Read only Views.

Lastly there is an another view named as Materialized Views.

3. View is used for the purposes as stated below:

a) Security

b) Faster Response

c) Complex Query solve

4.Syntax is :

Create or replace view([olumn1],[column2]...)

as

Select column1,column2...

from table_name

[where condition]

[with read only],[with check option]