/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 votes381 views3 answers
Row number mssql
SQL
0 vote359 views2 answers
Plsql regex match whole word
SQL
0 vote406 views1 answer
Postgresql custom order by
SQL
0 vote377 views1 answer
Group by max date
SQL
0 vote362 views1 answer
Sql DATE = GETDATE()
SQL
-1 vote376 views1 answer
SQL query to convert DD/MM/YYYY to YYYY-MM-DD
SQL
0 vote341 views1 answer
Minecraft duping allowed servers
SQL
4 votes331 views2 answers
Oracle set date format
SQL
21 votes401 views5 answers
Oracle all tables
SQL
0 vote375 views1 answer
Psql generate id in existing database
SQL