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 votes143 views1 answer
Invalid reference to FROM-clause entry for table "unidades
SQL
2 votes212 views2 answers
Postgres set user as superuser
SQL
0 vote200 views1 answer
Insert into table with only identity column
SQL
0 vote154 views1 answer
Oracle sql developer closed connection
SQL
0 vote157 views1 answer
Sql DATE = GETDATE()
SQL
0 vote178 views1 answer
How to run mysql on terminal mac
SQL
0 vote150 views1 answer
Min and max salary and name in sql
SQL
0 vote176 views1 answer
Psql no such file or directory
SQL
0 vote170 views1 answer
Createdb with postgresql on ubuntu
SQL
1 vote148 views1 answer
What is intersect
SQL