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 vote181 views1 answer
Mysql create table columns with spaces
SQL
9 votes193 views2 answers
Oracle all tables in schema
SQL
8 votes205 views1 answer
Declare table variable sql server
SQL
1 vote224 views1 answer
Sql server: query to find out all the places where the table is used
SQL
24 votes192 views5 answers
Sql reset auto increment
SQL
0 vote202 views1 answer
Sql last 7 days
SQL
0 vote207 views2 answers
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created at' in 'field list' (SQL: insert into `categories` (`category_name`, `user_id`, `created at`) values (sea fish, 1, 2021-09-24 04:17:31))
SQL
4 votes207 views3 answers
Mysql modify foreign key
SQL
0 vote208 views1 answer
Sql server bool select
SQL
1 vote206 views1 answer
Sql Split string function
SQL