Ddl 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

15 votes244 views2 answers
How to sort names in alphabetical order in sql
SQL
0 vote110 views1 answer
Wordpress sql change site url
SQL
0 vote105 views1 answer
How to find columns with null values in sql
SQL
3 votes102 views1 answer
Oracle rollback
SQL
0 vote114 views1 answer
No suitable driver found for sqlite
SQL
0 vote98 views1 answer
Sql join on a subquery
SQL
3 votes65 views1 answer
Postgresql where current year
SQL
14 votes111 views4 answers
Import database through command line
SQL
0 vote121 views1 answer
Selecting Multiple Columns in SQL
SQL
2 votes110 views2 answers
Storing timezones in postgres
SQL