Oracle Materialized View DDL
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:
- Oracle Materialized View Manual Refresh
Following is the call that...
- TOAD SQL Editor Useful Shortcuts
SHIFT-F9 This will run only...
- Oracle Rename Table – Example Syntax and Dependencies
Renaming a table in Oracle...
- Oracle Rename Column – alter table, rename column Example SQL Syntax
Following is simple example syntax...
- 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...
- Oracle SQL Subselect Statements
It is becoming more common...
- Oracle Autoincrement
Unlike Oracle, other less expensive...
- alter table, add column – Oracle Example Syntax
Following is simple example syntax...

Recent Comments