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 vote230 views1 answer
Cahnge column name apex oracle
SQL
0 vote212 views1 answer
What is the difference between now() and current_date()?
SQL
0 vote225 views3 answers
Postgres date difference seconds
SQL
7 votes209 views3 answers
Select latest entry in sql table
SQL
0 vote230 views1 answer
Joomla execute raw sql
SQL
0 vote204 views1 answer
Is there a way to use read_sql_query and the query has WHERE column = Variable?
SQL
2 votes190 views1 answer
Drop table if exists in postgres
SQL
0 vote209 views1 answer
Sql server check whether column has same equal values
SQL
0 vote219 views1 answer
Sqlite3_open_v2
SQL
0 vote189 views1 answer
Stuff in sql server
SQL