1. View is logical representation of the table.
2. View is derived from the table.
3. view don't occupy any memory space.

purpose.
1. Security
2. Simplicity of the query.

Another Important Point : view is updatble.

By
Kumar.T