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 vote143 views1 answer
How to display value of variable in mysql
SQL
0 vote132 views1 answer
Sql delete where x or y or z
SQL
0 vote137 views1 answer
Limit and offset in stored procedure mssql
SQL
0 vote133 views1 answer
Java sql insert return id
SQL
0 vote151 views1 answer
SQLSTATE[42S02]: Base table or view not found: 1146 Tabl
SQL
0 vote133 views1 answer
Illuminate\Database\QueryException SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client (SQL: select * from information_schema.tables where table_schema = blog and table_name = migrations and table_type = 'BASE TABL
SQL
0 vote171 views1 answer
Tsql cte in a transaction
SQL
0 vote148 views1 answer
Time mysql w3
SQL
0 vote133 views3 answers
ChAnge TABLE name apex oracle
SQL
0 vote139 views1 answer
Change role postgres
SQL