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 vote178 views1 answer
Query for all indexes in table postgres
SQL
0 vote172 views1 answer
Postgresql create table with boolean column
SQL
0 vote165 views1 answer
Show size of all tables postgres
SQL
1 vote193 views2 answers
One to one and one to many relationship
SQL
0 vote164 views1 answer
Get the Domain Name, Page Name and Query Parameter from a URL
SQL
0 vote160 views1 answer
Case insensitive sql
SQL
0 vote157 views1 answer
Sql gather statistics to increase performance
SQL
-1 vote223 views1 answer
MYSQL stored procedure select from
SQL
3 votes188 views1 answer
Where id is in list sql
SQL
0 vote135 views1 answer
Java spring boot connect to sql server
SQL