Oracle view ddl

-- 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 vote329 views1 answer
Sql select min
SQL
-1 vote324 views1 answer
Mac mysql workbench console
SQL
3 votes326 views3 answers
Cannot truncate a table referenced in a foreign key constraint
SQL
1 vote288 views1 answer
Enable mysql slow query log
SQL
1 vote344 views1 answer
Select users with same username
SQL
-1 vote319 views1 answer
Ssql to lowercqse
SQL
0 vote318 views1 answer
Jooq replace
SQL
1 vote344 views2 answers
Backup table mssql
SQL
1 vote342 views2 answers
Identify rows with 2 same column value and delete duplicate mysql
SQL
0 vote312 views1 answer
How to increase the width of the screen in oracle
SQL