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

17 votes349 views3 answers
Postgresql list users
SQL
1 vote309 views1 answer
Sql pick random row
SQL
9 votes310 views4 answers
Oracle get table column names
SQL
-1 vote320 views1 answer
Auto increment psql not primary key
SQL
3 votes327 views2 answers
Oracle sql first day of month
SQL
0 vote286 views1 answer
Oracle search in date columns
SQL
0 vote347 views1 answer
Eliminate zero from integer mysql
SQL
0 vote299 views1 answer
Update one column from another column in same table
SQL
-1 vote344 views1 answer
Add 10 to all numbers in a column sql
SQL
-1 vote319 views1 answer
SQL SERVER microsoft How to Add Column at Specific Location in Table
SQL