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]

A view may be thought of as a virtual table that is a table that does not really exist in its own right but is instead derived from one or more underlying base table. In other words there is no stored file that direct represents the view instead a definition of view is stored in data dictionary.
Growth and restructuring of base tables is not reflected in views. Thus the view can insulate users from the effects of restructuring and growth in the database. Hence accounts for logical data independence.

There are two type of views:

1 simple view

2 complex view

Types of Views:
a)
DataBase View
b) Help View
c) Projection View
d) Maintenance View

Use of views
A view provides the mechanism to hide certain data from the view of certain users.

Syntax:
use XXX (your database name)
GO
CREATE VIEW view1(view name)
AS
SELECT -------
-----------------(your query)
-----------------