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

0 vote350 views1 answer
How to write if case in select query in select statement
SQL
-1 vote341 views1 answer
Mysql select count if contains
SQL
0 vote379 views1 answer
VERIFY INDEXES WITH PARTITIONS IN SQL ORACLE
SQL
0 vote321 views1 answer
Components/Fields of Internal Table
SQL
0 vote313 views1 answer
First mysql
SQL
0 vote310 views1 answer
Version and edition of SQL Server Database Engine
SQL
0 vote319 views1 answer
Install mysql 8 linux
SQL
1 vote327 views3 answers
How to truncate foreign key constraint table
SQL
0 vote298 views1 answer
Sql requete number pair
SQL
1 vote297 views2 answers
Into sql
SQL