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

2 votes376 views1 answer
How to check if a row is null in sql
SQL
20 votes316 views2 answers
Counting in sql
SQL
0 vote319 views1 answer
What is mysql_pconnect
SQL
0 vote322 views1 answer
Datagrip exec
SQL
3 votes320 views2 answers
Sqlite show table definition
SQL
0 vote327 views1 answer
Drop unique
SQL
0 vote365 views1 answer
SQL server datetime compare
SQL
2 votes392 views1 answer
Cannot return non-composite value from function that returns composite type
SQL
1 vote334 views1 answer
Drop df constraint sql server
SQL
6 votes347 views1 answer
Oracle pl sql source
SQL