Oracle view ddl

-- 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 vote145 views1 answer
Get created time of database psql 8
SQL
3 votes117 views1 answer
Mssql remove column
SQL
0 vote195 views1 answer
Sql if clause within where clause
SQL
3 votes126 views2 answers
Mysql HAVING
SQL
0 vote175 views1 answer
Variable 'sql_mode' can't be set to the value of 'no_auto_create_user'
SQL
0 vote130 views1 answer
Sql change column in existing table
SQL
0 vote127 views1 answer
Select row with latest date mysql
SQL
1 vote123 views1 answer
Get table which have specific columns in mysql
SQL
1 vote141 views2 answers
Full join
SQL
0 vote129 views1 answer
Import excel to sql
SQL