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 vote144 views1 answer
Tsql cte in a transaction
SQL
0 vote97 views1 answer
What are the aggregate function in sql
SQL
1 vote113 views1 answer
Psql connections
SQL
0 vote117 views1 answer
"Hello User Name"
SQL
0 vote109 views1 answer
Sql server count all tables rows
SQL
0 vote121 views1 answer
Mysql order by where condition sub query
SQL
0 vote100 views1 answer
Sql random decimal
SQL
1 vote128 views2 answers
Setval max id postgresql sequence
SQL
11 votes110 views1 answer
Sql query to find duplicates in column
SQL
0 vote117 views1 answer
Mysql wsrep ls
SQL