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

3 votes284 views2 answers
Coalesce mysql
SQL
0 vote304 views1 answer
Sql update subtract value
SQL
3 votes316 views2 answers
SqlMessage: "Host '192.168.64.1' is not allowed to connect to this MariaDB server
SQL
-1 vote311 views4 answers
Postgres between dates
SQL
1 vote286 views1 answer
How to run parallel queries in sql server with entity framework
SQL
1 vote299 views1 answer
Mysql view current queries
SQL
0 vote287 views1 answer
Mysql add to value
SQL
0 vote309 views1 answer
Delete record by id sql
SQL
0 vote316 views1 answer
Nuget sqllite-net-pcl
SQL
0 vote293 views4 answers
Best data type to represent money in mysql
SQL