Oracle export view ddl

-- 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

1 vote219 views2 answers
Mysql show views
SQL
1 vote244 views1 answer
Oracle see column type
SQL
0 vote231 views1 answer
Express api ith mysql data
SQL
8 votes234 views1 answer
Oracle alter tablespace add datafile autoextend max size
SQL
9 votes243 views2 answers
SELECT User,Host FROM mysql.user;
SQL
0 vote176 views1 answer
Bigquery information_schema schema all columns
SQL
0 vote215 views1 answer
Longtext sql
SQL
0 vote203 views1 answer
Dump only schema
SQL
0 vote235 views1 answer
Mysqli::query(): (HY000/1034): Index for table 'db' is corrupt; try to repair it
SQL
5 votes270 views1 answer
Oracle source query
SQL