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

2 votes149 views2 answers
Create table mysql integer NOT null
SQL
0 vote94 views1 answer
Start stop mysql linux
SQL
2 votes97 views1 answer
Mysql trigger after update
SQL
9 votes118 views3 answers
Postgres make sql dump
SQL
5 votes102 views1 answer
Purge undo tablespace oracle 11g
SQL
-1 vote109 views4 answers
Restart mysql server ubuntu
SQL
0 vote102 views1 answer
Search from comma separated values in sql server
SQL
0 vote106 views1 answer
Sql server user permissions and roles
SQL
0 vote111 views1 answer
Mysql get longest string in column
SQL
0 vote113 views1 answer
Sql check if column exists
SQL