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

1 vote220 views2 answers
How to add amount between date in sql
SQL
0 vote198 views1 answer
Table values functions in SQL
SQL
0 vote209 views1 answer
Mysql value ends with
SQL
1 vote187 views2 answers
Sql convert datetime to year month
SQL
5 votes176 views1 answer
Invalid column name sql
SQL
10 votes188 views4 answers
Drop primary key
SQL
0 vote181 views1 answer
Mysql 5.7 in centos 7
SQL
-1 vote220 views1 answer
Create view in mysql workbench
SQL
1 vote194 views1 answer
Best configuration for display table in sqlplus
SQL
1 vote177 views2 answers
String to date postgres
SQL