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

22 votes193 views4 answers
Mysql reset auto increment id
SQL
1 vote207 views1 answer
Sql server: query to find out all the places where the table is used
SQL
1 vote212 views1 answer
Tsql update datetime
SQL
5 votes202 views4 answers
Select random rows sql
SQL
21 votes266 views6 answers
Update sql
SQL
1 vote201 views1 answer
Sql try catch
SQL
0 vote162 views1 answer
Mysql timeout 30 seconds
SQL
0 vote215 views1 answer
Postgresql custom order by
SQL
3 votes240 views1 answer
Postgres update column with value from another table
SQL
0 vote197 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