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

0 vote317 views1 answer
Mysqli_connect using prepare statement
SQL
1 vote288 views1 answer
Type int in mysql maxlenght
SQL
0 vote314 views1 answer
Postgres clear table
SQL
7 votes260 views1 answer
Alter table add key sql
SQL
12 votes307 views4 answers
Mysql ifnull
SQL
0 vote332 views1 answer
Mysql url
SQL
1 vote318 views1 answer
Age postgres
SQL
4 votes336 views6 answers
List all tables in postgres
SQL
5 votes352 views2 answers
How to ascending order in sql
SQL
0 vote298 views1 answer
Java spring boot connect to sql server
SQL