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

3 votes287 views1 answer
System.debug apex
SQL
1 vote274 views2 answers
OSError: mysql_config not found mysql_config --version mariadb_config --version mysql_config --libs ---------------------------------------- ERROR: Command errored out with exit status 1: python setup.py egg_info Check the logs for full command outpu
SQL
0 vote311 views1 answer
Query to insert image
SQL
0 vote307 views2 answers
CREATE TABLE researcher ( researcherid serial PRIMARY KEY, name text );
SQL
0 vote266 views1 answer
Import csv to mysql
SQL
0 vote329 views1 answer
Codeigniter MySQL - Issue with SELECT & GROUP BY
SQL
7 votes309 views1 answer
Safe mode mysql
SQL
0 vote317 views1 answer
Mysql Like(searching in the string)
SQL
11 votes310 views2 answers
Safe mode off mysql
SQL
0 vote334 views1 answer
T sql dynamic top n query
SQL