Oracle 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

-1 vote317 views1 answer
Concat two columns in sql server
SQL
42 votes373 views6 answers
Install beautifulsoup
SQL
1 vote322 views1 answer
Mysql select from outside
SQL
6 votes306 views3 answers
Mysql change auto_increment start value
SQL
0 vote314 views1 answer
How to get specific salary in sql
SQL
0 vote295 views2 answers
Create new table plsql
SQL
0 vote318 views1 answer
Mysql 5.7 in centos 7
SQL
0 vote316 views1 answer
Add mysql database to power bi web
SQL
4 votes308 views1 answer
Invalid reference to FROM-clause entry for table "unidades
SQL
0 vote364 views1 answer
Error Code: 1267. Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '=' 0.000 sec
SQL