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 vote347 views1 answer
Sql query interview questions githu
SQL
0 vote333 views1 answer
Import all databases mysql
SQL
1 vote341 views1 answer
Local sql server
SQL
0 vote359 views2 answers
Sql query in dax power bi
SQL
3 votes340 views4 answers
Show columns from table
SQL
0 vote350 views1 answer
No suitable driver found for sqlite
SQL
0 vote344 views1 answer
Drop all triggers oracle
SQL
0 vote362 views1 answer
Como hacer una consulta en sql
SQL
0 vote355 views1 answer
Report in database
SQL
0 vote372 views1 answer
Sql query to find difference between total no. of rows and distinct rows in sql server
SQL