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

8 votes338 views1 answer
Unique vs primary key
SQL
1 vote368 views1 answer
Setval pgsql
SQL
0 vote323 views0 answer
SQL
62 votes475 views8 answers
Mysql add column
SQL
0 vote338 views1 answer
How to check default value of column in sql server
SQL
-1 vote353 views1 answer
Mysql select all columns and specific fields as
SQL
1 vote379 views2 answers
One to one and one to many relationship
SQL
0 vote372 views1 answer
Oracle swap partition
SQL
1 vote429 views1 answer
Mysql get max value and id
SQL
0 vote343 views1 answer
Reset keys in sql
SQL