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 vote177 views1 answer
Delete triger pl pg sql
SQL
3 votes198 views1 answer
Sql double index
SQL
7 votes196 views3 answers
Sql set
SQL
1 vote247 views1 answer
Sample clause in sql
SQL
0 vote184 views1 answer
Check sql database table lock
SQL
0 vote213 views1 answer
Product of a column in mysql
SQL
0 vote212 views1 answer
Sql last time database was accessed
SQL
0 vote216 views1 answer
Space not removing from column in sql
SQL
0 vote197 views1 answer
Sql server select ignore dupplicates
SQL
3 votes187 views4 answers
Show sql server database
SQL