/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

1 vote377 views1 answer
Mysql select row max date
SQL
20 votes358 views1 answer
Sql change column types
SQL
0 vote366 views2 answers
Compound operator in sql
SQL
0 vote299 views1 answer
Requete sql mise a jour content dans un colone mysql
SQL
0 vote346 views1 answer
Sql get month and year from date
SQL
3 votes393 views2 answers
Update part of a string in mysql
SQL
0 vote338 views1 answer
Drop column from local database postgres pgadmin
SQL
3 votes416 views1 answer
Oracle list invalid password logon denied
SQL
0 vote378 views1 answer
Cartesian product sql
SQL
6 votes386 views2 answers
Foreign key sqlite3 python
SQL