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

22 votes356 views4 answers
Mysql date_format
SQL
0 vote328 views1 answer
Prepared statement mysql java delete selected rows
SQL
104 votes541 views2 answers
Like in mysql
SQL
1 vote309 views2 answers
Mysql SELECT
SQL
3 votes338 views1 answer
Null sql
SQL
0 vote401 views1 answer
Oracle convert int to date
SQL
0 vote358 views2 answers
How to Alter column in SQL Server - NAYCode.com
SQL
1 vote358 views1 answer
How to use db.execute
SQL
5 votes351 views3 answers
Show indexes mysql
SQL
44 votes384 views6 answers
Rename command in sql
SQL