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

1 vote143 views2 answers
How to drop a unique constraint in sql
SQL
0 vote145 views1 answer
Create table split string function in sql server
SQL
8 votes134 views4 answers
Mysql update one table from another table multiple columns
SQL
0 vote125 views1 answer
Minecraft duping allowed servers
SQL
1 vote148 views1 answer
Events mysql
SQL
0 vote125 views1 answer
How to get initials in sql
SQL
0 vote144 views1 answer
Mysql make date from 2 column
SQL
0 vote158 views1 answer
Leftjoin in sql
SQL
6 votes134 views4 answers
How to remove unique key in mysql
SQL
4 votes132 views1 answer
Add constraint fk
SQL