/SQL/How to get ddl for materialized view

How to get ddl for 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 vote119 views1 answer
Sql server alter table add column tinyint
SQL
0 vote130 views1 answer
Docker open terminal mysql server
SQL
0 vote117 views1 answer
Find usage of table in sql server
SQL
0 vote117 views1 answer
Char vs varchar2 in sql
SQL
0 vote109 views2 answers
Mysql regexp match word
SQL
4 votes113 views1 answer
Oracle show errors compilation
SQL
0 vote115 views4 answers
Mysql replace regex
SQL
0 vote130 views1 answer
Npm ERR! code ELIFECYCLE npm ERR! errno 1 npm ERR! [email protected] install: `node-pre-gyp install --fallback-to-build` npm ERR! Exit status 1 npm ERR! npm ERR! Failed at the [email protected] install script.
SQL
0 vote119 views1 answer
Sql server alter table column nullable
SQL
4 votes122 views1 answer
Wilayah indonesia sql
SQL