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 vote278 views3 answers
Mysql CAST(amount as float)
SQL
1 vote227 views1 answer
Sql server locks
SQL
-1 vote202 views10 answers
Delete Query in SQL Server
SQL
3 votes220 views1 answer
Ms sql skip take
SQL
0 vote222 views1 answer
Mysql export data with a where clause
SQL
8 votes215 views1 answer
Oracle add month
SQL
1 vote227 views1 answer
Lpad function in sql oracle
SQL
11 votes256 views6 answers
Mysql else if
SQL
0 vote254 views5 answers
How to make trigger in phpmyadmin
SQL
0 vote198 views1 answer
CREATE MULTIPLE FK
SQL