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

9 votes231 views3 answers
Show table columns mysql command line
SQL
2 votes220 views2 answers
How to get capital letter first in sql
SQL
0 vote277 views1 answer
Sql alternative to max statement
SQL
1 vote231 views1 answer
Cannot insert explicit value for identity column in table 'Tbl_Increment_File' when IDENTITY_INSERT is set to OFF.
SQL
1 vote219 views1 answer
Input in mysql
SQL
0 vote233 views1 answer
Returning with sqlalchemy
SQL
3 votes225 views1 answer
How to check schema privileges in oracle
SQL
0 vote238 views3 answers
Classement rang mysql 7
SQL
0 vote238 views1 answer
Select 1 from orders
SQL
0 vote233 views1 answer
Sql query tags
SQL