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 vote312 views1 answer
Replace null value within column mysql
SQL
0 vote432 views2 answers
Sqlalchemy default value for column
SQL
0 vote368 views2 answers
Sql unique
SQL
1 vote339 views1 answer
Error code 1292 mysql workbench
SQL
8 votes307 views1 answer
Oracle find text in functions
SQL
0 vote299 views1 answer
Create dabase postgresql
SQL
-1 vote294 views2 answers
Sql query examples
SQL
0 vote313 views2 answers
Mysql get routine parameter list
SQL
0 vote335 views1 answer
Postgresql function ROUND
SQL
24 votes315 views4 answers
Mssql get all table names
SQL