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 vote213 views1 answer
Python dictionary to sql update
SQL
0 vote208 views1 answer
Show size of all tables postgres
SQL
0 vote204 views1 answer
Sql transact create cursor with dynamic tables
SQL
0 vote182 views1 answer
How to find unique key in sql
SQL
0 vote198 views1 answer
Console output pl sql
SQL
0 vote221 views2 answers
Mysql dump structure only
SQL
0 vote214 views1 answer
Snowflake drop column
SQL
0 vote209 views1 answer
How to return only the Date from a SQL Server DateTime datatype
SQL
1 vote259 views1 answer
Mysql stop password policy
SQL
1 vote227 views1 answer
Sql group by sum with condition
SQL