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 vote329 views1 answer
Add colum date in sql
SQL
3 votes353 views2 answers
Sql end of month
SQL
1 vote342 views1 answer
CREATE DATABASE db; SyntaxError: Unexpected identifier
SQL
-1 vote367 views1 answer
Pl/sql how to delete a trigger
SQL
0 vote354 views1 answer
How to run mysql in git bash
SQL
0 vote344 views1 answer
On sql table data exists
SQL
61 votes544 views6 answers
Mysql add column
SQL
4 votes342 views2 answers
How to insert ip address in mysql using php
SQL
1 vote355 views1 answer
Mysql alter decimal precision
SQL
0 vote351 views1 answer
A good way of running a SQL query in JDBC using a parameterized statement
SQL