Home arrow Technical Tips arrow Oracle arrow Oracle Materialized View DDL
Oracle Materialized View DDL Print E-mail
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:

select query from user_mviews where mview_name='[MV_NAME]';

Enjoy!