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

6 votes348 views2 answers
Mysql check auto increment value
SQL
10 votes373 views4 answers
Drop primary key
SQL
0 vote331 views1 answer
How many columns can be used for creating index?
SQL
0 vote406 views1 answer
How to locate pg_hba.conf file
SQL
0 vote400 views1 answer
Sql constarint
SQL
1 vote345 views1 answer
Python escape string for sql
SQL
1 vote349 views1 answer
Mysqlworkbench Your connection attempt failed for user 'root' from your host to server at 127.0.0.1:3306: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/mysql/lib/plugin/caching_sha2_password.so, 2): image not found
SQL
0 vote454 views1 answer
Restart serial number for postgres
SQL
2 votes344 views1 answer
Match in sql server
SQL
4 votes345 views1 answer
Postgresql change default value
SQL