1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Info needed about materialized Views

Discussion in 'SQL PL/SQL' started by sandip250382, Jun 4, 2010.

  1. sandip250382

    sandip250382 Active Member

    Messages:
    10
    Likes Received:
    0
    Trophy Points:
    80
    Can anyone here let me know what is a materialized view with a nice example. Only theoretical declination is not needed. Kindly give a nice coding example of materialized view. Thanks in advance.
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    The Oracle online documentation has many examples -- start reading here

    http://www.oracle.com/pls/db102/search?word=materialized+view&partno=