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

0 vote236 views2 answers
How to combine diff colmun value using group by postgres
SQL
0 vote276 views1 answer
How to change mysql root password in windows 10
SQL
2 votes226 views1 answer
Update trigger
SQL
9 votes252 views4 answers
Mysql set id auto increment
SQL
0 vote249 views1 answer
Sql server synonym
SQL
1 vote282 views1 answer
Postgresql Insufficient privilege: 7 ERROR: permission denied for table
SQL
6 votes296 views3 answers
What is where in sql
SQL
2 votes228 views1 answer
Oracle index size
SQL
0 vote234 views1 answer
Sql "List the contact methods found in the Contact table.For each contact method, list how many people chose that contact method."
SQL
36 votes235 views3 answers
Finding duplicate column values in table with sql
SQL