This content has been marked as final. Show 3 replies
Check out these -
(contains Table creation, Insert statements and MView scripts)
Practically do the workouts and reading the theory alone will not help.
Just saw what Jeneesh replied and absolutely agree to it. +'No substitute/shortcut to learning and success'+ .
Keep patience and read the Oracle documentation thoroughly. It will contain every possible clause possible with MViews.
No other material will provide such an in-depth knowledge as the official documentation.
Please read -
 <b>Materialized View : Concept & Architecture</b>
 <b>Materialized View : Create</b>
Edited by: ranit B on Dec 31, 2012 3:07 PM
-- doc links added