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

4 votes439 views3 answers
Mysql get column names from table
SQL
0 vote340 views1 answer
Postgres execute multiple sql file from command line
SQL
1 vote362 views2 answers
Oracle create synonym
SQL
0 vote344 views1 answer
Apache Derby: Create SQL Dump with data
SQL
0 vote342 views1 answer
How to order result of subquery in select
SQL
12 votes339 views1 answer
Docker mysql random root password
SQL
21 votes321 views6 answers
Docker run mysql
SQL
0 vote386 views1 answer
Mariadb disable foreign key checks
SQL
0 vote358 views1 answer
Convert multiple columns to ROws in sql server
SQL
0 vote354 views1 answer
Kill mysqld_safe process mariadb
SQL