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 vote186 views1 answer
Sql alter table add column if exists
SQL
4 votes171 views1 answer
Alter session set nls_date_format
SQL
0 vote139 views1 answer
Https://livesql.oracle.com/apex/livesql/s/l8fedwph53gt5gigbacwvu6m0
SQL
2 votes172 views1 answer
Show max_allowed_packet mysql
SQL
-1 vote139 views1 answer
Partial search in sql
SQL
18 votes163 views2 answers
Find all tables containing column with specified name - MS SQL Server
SQL
1 vote214 views1 answer
Adding a check statement in sql
SQL
0 vote132 views1 answer
Sql select lowest value row
SQL
0 vote163 views1 answer
Mysql auto increment default value with prefix month and year
SQL
0 vote136 views1 answer
Postgres enumerated type
SQL