Oracle export 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 vote145 views1 answer
Oracle webcenter content search enginer
SQL
4 votes178 views1 answer
Mysql query first character
SQL
4 votes135 views3 answers
Order by value mysql
SQL
15 votes148 views2 answers
Select where duplicate mysql
SQL
0 vote135 views1 answer
Xampp mysql version
SQL
1 vote138 views1 answer
Trigger in postgresql to change incoming entry
SQL
0 vote142 views1 answer
Watch mysql command line
SQL
0 vote143 views2 answers
Postgres another version
SQL
6 votes127 views5 answers
Get current date sql
SQL
0 vote132 views1 answer
Get all employee of salary if more than in sql
SQL