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 votes164 views1 answer
Sql alchemy or
SQL
1 vote168 views1 answer
Sql select where id not exists in another table
SQL
0 vote187 views2 answers
Sqlite unique
SQL
5 votes174 views3 answers
Oracle list columns in schema
SQL
5 votes194 views1 answer
Oracle get ddl
SQL
0 vote177 views1 answer
Get number of rows in every table mysql
SQL
0 vote178 views1 answer
Drop database using terminal postgres
SQL
5 votes171 views1 answer
Mysql created at yesterdau
SQL
46 votes177 views4 answers
Create column sql
SQL
0 vote187 views1 answer
Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'autos_id' in 'field list' in
SQL