Ddl 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 vote131 views1 answer
Sql server loop over query
SQL
0 vote107 views1 answer
How to start my sql server on mac
SQL
0 vote96 views1 answer
Sql select most frequent value in group
SQL
5 votes64 views1 answer
Mongodb vs
SQL
1 vote117 views1 answer
Oracle drop job if exists
SQL
37 votes109 views3 answers
Duplicate records in sql
SQL
0 vote95 views1 answer
How to user id to show in from date to upto date in mssql server
SQL
0 vote60 views0 answer
SQL
0 vote121 views2 answers
Call to undefined function mysql_query()
SQL
0 vote112 views1 answer
Java check if something is in mysql table
SQL