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 vote231 views1 answer
Oracle grant create job
SQL
0 vote246 views1 answer
How to update date value in sql
SQL
1 vote242 views3 answers
Mysql parse int
SQL
11 votes241 views5 answers
Update table from another table mysql
SQL
0 vote239 views1 answer
Sql server set complex constraints
SQL
16 votes246 views3 answers
Get count of duplicate records
SQL
0 vote217 views1 answer
Truncate a table then insert data
SQL
3 votes235 views2 answers
Brew restart mysql
SQL
0 vote222 views2 answers
Create sequence if not exists postgres
SQL
1 vote196 views1 answer
Insert into sql
SQL