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

54 votes289 views6 answers
Sql rename column
SQL
0 vote111 views1 answer
Sqlite to csv statement
SQL
3 votes118 views1 answer
Sql multiple column index
SQL
0 vote132 views1 answer
Sqlalchemy get ids
SQL
2 votes186 views1 answer
Tsql copy table
SQL
3 votes116 views1 answer
Start mysql server linux terminal
SQL
2 votes142 views3 answers
Sql function
SQL
1 vote120 views2 answers
Drop function in sql
SQL
4 votes171 views1 answer
Sql select limit range
SQL
0 vote130 views1 answer
Migration graphql
SQL