Get ddl materialized view oracle

-- 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 vote187 views1 answer
Version_info, _mysql.version_info, _mysql.__file__ NameError: name '_mysql' is not defined
SQL
0 vote179 views1 answer
MySql count occurences more than"
SQL
0 vote178 views1 answer
Mysql search multiple tables
SQL
3 votes167 views1 answer
Oracle function
SQL
0 vote192 views1 answer
Oracle sql add column auto generated value
SQL
0 vote195 views1 answer
Mysql installer did not find packages in the current bundle suitable for installation
SQL
2 votes174 views1 answer
Sql server conection string
SQL
-1 vote129 views1 answer
Mysql how to set update or create
SQL
0 vote177 views1 answer
Select from another database
SQL
-1 vote181 views1 answer
Mysql case when multiple conditions
SQL