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

5 votes164 views1 answer
Oracle sysdate - 1 month
SQL
10 votes154 views2 answers
What is database
SQL
2 votes190 views3 answers
Xampp mysql database not starting
SQL
16 votes135 views2 answers
Add column to all tables after first column mysql
SQL
0 vote128 views1 answer
Mysql percentage of total
SQL
4 votes174 views1 answer
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.s
SQL
0 vote132 views1 answer
Json not contains mysql
SQL
2 votes133 views1 answer
Mysql sysdate
SQL
2 votes180 views6 answers
In operator in sql
SQL
0 vote134 views1 answer
Like sql for second letter of the family name
SQL