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 vote289 views1 answer
Sql show table name in result
SQL
2 votes280 views1 answer
Update with join sql server
SQL
5 votes263 views2 answers
Oracle tables with column name
SQL
1 vote284 views2 answers
How to combine 2 tables in MySQL
SQL
-1 vote275 views1 answer
Search all database tables for a value sqlserver
SQL
5 votes298 views4 answers
Traduction
SQL
0 vote264 views2 answers
Mysql multiply
SQL
0 vote286 views1 answer
Sql if clause within where clause
SQL
2 votes264 views2 answers
How to get capital letter first in sql
SQL
0 vote293 views1 answer
Is not numeric sql
SQL