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 vote97 views1 answer
Foreign key constraint in ms sql
SQL
1 vote111 views1 answer
Right outer vs left outer join
SQL
5 votes110 views1 answer
Find table from column name in sql
SQL
0 vote111 views1 answer
Initcap in mysql
SQL
0 vote117 views1 answer
When mysql server would not work in xampp
SQL
0 vote104 views1 answer
Console output pl sql
SQL
6 votes107 views1 answer
Postgres get size of database
SQL
0 vote127 views1 answer
Hashpass
SQL
1 vote105 views1 answer
Sql dcl
SQL
23 votes101 views6 answers
How to create table in sql
SQL