/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

7 votes171 views1 answer
Mysql load data infile csv
SQL
15 votes282 views6 answers
Drop foreign key mysql
SQL
0 vote198 views1 answer
List in one column mysql
SQL
11 votes203 views1 answer
Mysql text type max length
SQL
0 vote215 views1 answer
Mysql root localhost run
SQL
0 vote200 views1 answer
Add column to table with default value plsql
SQL
0 vote215 views1 answer
Ver usuarios mysql
SQL
0 vote205 views1 answer
Price-colour
SQL
3 votes205 views3 answers
Django.db.utils.OperationalError: no such table:
SQL
20 votes191 views2 answers
Counting in sql
SQL