1.you can provide required column to user ex.if table(id,Name,City) n u want to show only Name,City then create view view_table as select Name,City from table ----execute-- Select * from view_table

Security, Query Simplicity, Structural simplicity, Consistency, Data Integrity, Logical data independence, Performance, Update restrictions etc...

1. We can query more than one table using views.(complex queries) 2. Hide columns and expose only selected columns. So its restricting access to view the complete table. 3.Inserts and updates are not allowed in views. So its read only mode and hence you can use this for look ups and readonly grids.