Oracle view source

-- 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

5 votes188 views4 answers
Describe table postgres
SQL
1 vote242 views1 answer
Hackerrank sql test solutions
SQL
11 votes240 views6 answers
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
SQL
32 votes210 views6 answers
How to change column name in sql
SQL
2 votes255 views2 answers
Postgres set user as superuser
SQL
1 vote258 views1 answer
Ora-01950 no privileges on tablespace
SQL
1 vote204 views1 answer
Sqlstate[imssp]: the active result for the query contains no fields.
SQL
1 vote153 views1 answer
Oracle character set
SQL
0 vote189 views1 answer
Mysql Install Ubuntu with native password
SQL
-1 vote147 views3 answers
Ubuntu install mssql
SQL