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 vote300 views1 answer
Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'updated_at' in 'field list'
SQL
0 vote270 views1 answer
Sql right characters
SQL
3 votes305 views1 answer
Sql add two values together
SQL
0 vote309 views1 answer
Sql column contains special character
SQL
1 vote290 views1 answer
Check if mysql is installed
SQL
18 votes298 views3 answers
Mysql add column with default value
SQL
1 vote285 views2 answers
Mysql type conversion
SQL
3 votes315 views1 answer
Sql print all names that start with a given letter
SQL
0 vote299 views1 answer
How to check event scheduler status mysql
SQL
0 vote286 views1 answer
Sqlite higher or equal
SQL