Get ddl materialized view oracle

-- 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 vote162 views2 answers
Csv into data postgres
SQL
0 vote172 views1 answer
Sql list dates between two dates
SQL
0 vote168 views1 answer
How to count null values in sql
SQL
0 vote179 views1 answer
Mysql get first 2 characters of string
SQL
10 votes166 views5 answers
Create table mysql query
SQL
0 vote229 views1 answer
SHOW RESULT WITHOUT ROUND IN SQL
SQL
6 votes154 views5 answers
Get current date sql
SQL
3 votes170 views1 answer
Mysql set field unique
SQL
2 votes164 views1 answer
Anonymous block plsql
SQL
0 vote176 views1 answer
Psql check if sql script is valid
SQL