/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

0 vote116 views1 answer
Get last updated row sql server
SQL
2 votes105 views1 answer
Oracle sql drop column if exists
SQL
0 vote122 views1 answer
Drop CHECK constraint sql
SQL
9 votes139 views3 answers
Sql delete where in
SQL
0 vote117 views2 answers
Csv into data postgres
SQL
0 vote120 views1 answer
Mysql docker image for macbook m1
SQL
4 votes111 views2 answers
Sql select except null
SQL
16 votes114 views6 answers
Install sqlite3 python
SQL
0 vote119 views1 answer
Sql change column in existing table
SQL
0 vote114 views1 answer
Mysql sum with group by
SQL