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

1 vote225 views1 answer
Sql first
SQL
7 votes189 views1 answer
Sql management studio display line numbers
SQL
0 vote209 views2 answers
Which MySQL statement is used to delete data from a database
SQL
21 votes258 views3 answers
Average sql
SQL
0 vote201 views1 answer
New rails app with mysql
SQL
1 vote200 views2 answers
Sql left characters
SQL
0 vote186 views2 answers
Mysql create table if not exists
SQL
0 vote185 views1 answer
VSCode SQL Server Connection error
SQL
0 vote209 views1 answer
Psql attribute cannot login
SQL
0 vote255 views1 answer
Mysql remove last character
SQL