/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

9 votes314 views1 answer
Oracle get table schema
SQL
1 vote309 views3 answers
Mariadb add foreign key
SQL
4 votes328 views2 answers
How to insert ip address in mysql using php
SQL
4 votes319 views1 answer
Force drop all tables postgres
SQL
0 vote317 views1 answer
Como hacer un select entre fechas mysql
SQL
0 vote321 views1 answer
Mysql update from n to 100
SQL
0 vote327 views1 answer
Select from column mysql
SQL
0 vote325 views1 answer
Hw to delete a procedure in pl sql
SQL
0 vote315 views1 answer
What is mysql_pconnect
SQL
10 votes308 views1 answer
All_dependencies
SQL