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

14 votes204 views1 answer
Oracle alter table add column not null
SQL
0 vote258 views1 answer
Compare two tables to find unmatched records
SQL
0 vote185 views1 answer
Sql select most frequent value in group
SQL
0 vote213 views1 answer
Primary key start from number
SQL
0 vote185 views1 answer
Top frequency in sql server
SQL
10 votes182 views4 answers
Join with multiple conditions sql
SQL
13 votes188 views4 answers
Mysql get last row
SQL
2 votes246 views2 answers
Mysql write into table
SQL
0 vote193 views1 answer
Mysql create pool
SQL
0 vote197 views1 answer
Mysql events not work
SQL