ashok

• May 30th, 2006

 

views

        view is a combination of one or more table.view does not stores the data,it just store the query in file format.If we excutes the query the query will fetch the data from the tables and just make it to view for us.

types

views

materilized view

      

Sphurti

• Aug 9th, 2006

 

Hi,

As per definition, View is just an query which is parsed and stored in SGA. So whenever this view is referred in a query it can be executed with no lost of time for parsing.  Through views we can hide the complex and big names of the tables. One bigger advantage, just by creating a view once we can use it at many places.

Materialize View which is introduce in Oracle 8. It actually stores data like table.