•With views you can restrict database access in both column level and row level. Selective portion of tables can be hidden with view.
•Creating complex view and query on them allow you to make complex query easy. They allow you to make simple queries to retrieve the results from complicated queries.
•Views can be used to allow data independence for ad hoc users and application programs.
•You can present different views of the same data according to their particular criteria.
•For experiment you can just create view and query on them instead of creating temporary tables and dropping them while significantly reduce database fragmentation.
