Are you a TOAD fanatic when it comes to “anything-Oracle”? If so, you probably realized that TOAD will not show you the DDL for a materialized view in any of the tabs in the schema browser. The “Scripts” tab will look similar to a table’s script.
Following is an SQL statement you can run to find out the SQL used by the materialized view:
1 | SELECT query FROM user_mviews WHERE mview_name='[MV_NAME]'; |
Enjoy!
One Comment on “Oracle Materialized View DDL”
What’s up, I desire to subscribe for this website to obtain most recent updates, thus where can i do it please help.