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

2 votes214 views1 answer
Oracle trace file
SQL
-1 vote321 views1 answer
Get month and year from date in mysql sequelize
SQL
5 votes263 views1 answer
Migrate sql table another database
SQL
4 votes293 views4 answers
Remove duplicate old value in mysql
SQL
0 vote276 views1 answer
DATEDIFF minute postgres
SQL
0 vote295 views1 answer
Oracle db get table sizes
SQL
1 vote202 views1 answer
Blob datatype in mysql
SQL
0 vote162 views1 answer
Store query result in variable sql
SQL
11 votes199 views3 answers
Sql_mode=only_full_group_by
SQL
0 vote210 views2 answers
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'world.admin_tasks' doesn't exist
SQL