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

0 vote231 views1 answer
Python mysql check if database exists
SQL
2 votes137 views1 answer
Sql alchemy or
SQL
14 votes147 views2 answers
Oracle export trigger ddl
SQL
2 votes193 views3 answers
Xampp mysql database not starting
SQL
2 votes174 views2 answers
Postgres set user as superuser
SQL
1 vote164 views1 answer
Oracle user last connection date
SQL
0 vote146 views1 answer
Create table in mysql mariadb primary key foreign key
SQL
4 votes140 views4 answers
Start mysql
SQL
1 vote142 views1 answer
Set mysql mode global query
SQL
2 votes215 views2 answers
Mysql compare datetime to another datetime
SQL