/SQL/How to get ddl for materialized view

How to get ddl for materialized view

-- Views (use USER_VIEWS or DBA_VIEWS if needed):
SELECT TEXT FROM ALL_VIEWS WHERE upper(VIEW_NAME) LIKE upper('%VIEW_NAME%');
-- Or:
SELECT dbms_metadata.get_ddl('VIEW', 'VIEW_NAME', 'OWNER_NAME') FROM DUAL;

-- Materialized views (use USER_VIEWS or DBA_VIEWS if needed):
SELECT QUERY FROM ALL_MVIEWS WHERE upper(MVIEW_NAME) LIKE upper('%VIEW_NAME%');
-- Or:
SELECT dbms_metadata.get_ddl('MATERIALIZED_VIEW', 'VIEW_NAME', 'OWNER_NAME') 
FROM DUAL;

Source: oracle-base.com

Similar codes

2 votes246 views2 answers
Mysql does sentence contain word
SQL
0 vote201 views1 answer
Oracle drop default value
SQL
0 vote211 views1 answer
Sql character index
SQL
5 votes225 views6 answers
Sql foreign key
SQL
0 vote218 views1 answer
Two inner joins sql
SQL
5 votes201 views2 answers
Mysql where in array
SQL
3 votes212 views2 answers
How to start mysql in terminal
SQL
0 vote222 views1 answer
MySql shutdown unexpectedly InnoDB: Mutexes and rw_locks use Windows interlocked functions InnoDB: Uses event mutexes
SQL
0 vote176 views1 answer
Store query result in variable sql
SQL
1 vote225 views1 answer
Sql view where tables have same column name combine results
SQL