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

1 vote271 views2 answers
Login to mysql
SQL
0 vote262 views1 answer
Drop all procedures sql server
SQL
0 vote220 views2 answers
Jupyter notebook connect to database
SQL
1 vote286 views1 answer
Retrieve meaning
SQL
10 votes262 views6 answers
Between sql
SQL
0 vote261 views1 answer
Sqlite3 get data from table c
SQL
24 votes270 views2 answers
Alter table delete column
SQL
4 votes312 views1 answer
Ms sql truncate table vs delete
SQL
0 vote308 views1 answer
Mysql relationships between tables
SQL
0 vote268 views1 answer
Use where instead of join
SQL