Ddl view

-- 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

1 vote90 views1 answer
VERIFY INDEXES IN SQL ORACLE
SQL
2 votes107 views1 answer
SQLSTATE[HY000] [1049] Unknown database
SQL
-1 vote159 views3 answers
MAKE TABLE FIT in oracle sql
SQL
1 vote104 views1 answer
Xampp import sql file command line
SQL
0 vote109 views1 answer
What is server_default = func.now() in sqlalchemy
SQL
0 vote111 views1 answer
Get a list of tables and the primary key
SQL
1 vote95 views2 answers
Mysql error 1215
SQL
0 vote99 views1 answer
Call rest api from postgresql
SQL
0 vote109 views1 answer
Exit psql
SQL
0 vote115 views1 answer
WHERE not regex in SQL
SQL