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 vote144 views1 answer
H2 auto increment and unique
SQL
1 vote134 views1 answer
$query = mysqli_query($con, $sql); while ($row = mysqli_fetch_array($query))
SQL
-1 vote152 views1 answer
An error occurred while installing mysql (2.9.1), and Bundler cannot continue
SQL
-1 vote143 views1 answer
Partial search in sql
SQL
0 vote132 views1 answer
Oracle search columns in schema
SQL
0 vote149 views1 answer
Systems sql
SQL
1 vote154 views1 answer
Mysql order by desc null last
SQL
3 votes152 views1 answer
Oracle undo tablespace schema
SQL
0 vote177 views3 answers
Mysql CAST(amount as float)
SQL
1 vote154 views1 answer
Oracle compile schema
SQL