Advantages of Views
1) They provide an additional level of table security by restricting accessto a predeterminded set of rows and / or columns of a table.
2) They hide data complexity
3) They simplify commands for the user because they allow to select informationfrom multiple tables without actually knowing how to perform a join .
4) They separate applications from changes idefinitions of base tables.
5) They provide data in a different perspective than that of a base table by renaming columns without affecting base table.
View Creation Option
1) Check Option
When creating a view will allow to user to update only noted rows ,which are viewable through this view and give an error when user try to override it.
2) Creating Views with Errors
Oracle will create the view even if the veiw defining query refers to anon - existing table ( or ) an invalid column of an existing table or when the view owner does not have the required privilages .To create a view with errors , include the FORCE option in the CREATE VIEW command.
Data Dictionary Table for Views User_Views will provide details of views that the user has created.
