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!

Related Information:

1. Oracle Materialized View Manual Refresh

   Following is the call that can be made to refresh your materialized view in Oracle manually: 1 execute DBMS_SNAPSHOT.REFRESH('[MV_NAME]','[refresh_option]'); Refresh...

2. TOAD for Oracle 9 or TOAD 10 - 64-bit Windows - ORA-12154: could not resolve the connect identifier specified or ORA-6413: connection not open

   I recently downloaded the new 10.x version of TOAD and could not connect to my databases. Still running TOAD 9.x,...

3. Oracle Rename Table - Example Syntax and Dependencies

   Renaming a table in Oracle is simple. Following is the generic Oracle table rename syntax: 1 ALTER TABLE current_table_name RENAME...

4. Oracle BPEL Email Notification - Remove Attachment

   If you have used the email notification activity in Oracle BPEL (up through the latest version at the time of...

5. Google Apps Reporting API - Not quite this easy with Exchange

   I have been somewhat enamored by Google Apps and its potential. Many enterprises have been happy with Exchange for mail,...

6. Oracle IdM - SAML SSO with Google Apps

   We recently integrated Oracle IdM with the SAML SSO Service from Google Apps. Now customers can continue to authenticate against...

7. Oracle Rename Column - alter table, rename column Example SQL Syntax

   Following is simple example syntax for renaming a column to an Oracle table using "alter table" SQL:
    
   ALTER...