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

0 vote194 views1 answer
Mysql join column order By and group By
SQL
0 vote181 views1 answer
Min and max salary and name in sql
SQL
0 vote215 views1 answer
Client does not support authentication protocol requested by server sqlyog
SQL
0 vote179 views1 answer
Mysql> grant all privileges on *.* to root@localhost identified by 'password' with grant option;
SQL
1 vote182 views1 answer
SQL query to get all table records count from a database
SQL
0 vote197 views1 answer
Sql cnvert bit to nvarchar
SQL
0 vote180 views2 answers
How to update date in oracle
SQL
1 vote196 views3 answers
Epoch to datetime
SQL
0 vote202 views1 answer
Sql use with to get value counts and percentages
SQL
0 vote190 views1 answer
Qt qsql check if table exist
SQL