Home » SQL & PL/SQL » SQL & PL/SQL » How views works? (Oracle 10g)
How views works? [message #388804] Thu, 26 February 2009 04:54 Go to next message
Messages: 122
Registered: July 2008
Location: bangalore
Senior Member
Dear All,
This might be the simple question,but i am trying in a different technical angle.I am not a DBA.
When we create views in oracle the info regarding views are stored in the database dictionary.So when ever we query the views it will reads the data from the base table,or the data belongs to the view will be in database buffer.Can any one give me a link on this topic how exactly this views work inside oracle and about materialized views.Need to have a profound knowledge on this part on how it works.

Re: How views works? [message #388808 is a reply to message #388804] Thu, 26 February 2009 05:00 Go to previous messageGo to next message
Michel Cadot
Messages: 63956
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Database Concepts

Re: How views works? [message #388850 is a reply to message #388808] Thu, 26 February 2009 06:35 Go to previous message
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Slightly better targetted link about Views
Previous Topic: Handling exceptions
Next Topic: Pls help with SQL
Goto Forum:

Current Time: Fri Oct 28 19:30:31 CDT 2016

Total time taken to generate the page: 0.16873 seconds