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

3 votes279 views4 answers
ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client vs code
SQL
-1 vote189 views1 answer
Get id from just inserted row mysql server python
SQL
0 vote199 views1 answer
Postgres sequence name
SQL
0 vote154 views1 answer
Copy data from cell to cell mysql
SQL
0 vote199 views1 answer
Closure in sql
SQL
0 vote143 views1 answer
How to get last client id sql
SQL
0 vote202 views1 answer
How to install Firebird
SQL
0 vote177 views1 answer
Edit a field mysql terminal
SQL
-1 vote311 views5 answers
Left join sql
SQL
1 vote221 views1 answer
Oracle list data files
SQL