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

0 vote150 views1 answer
Flask_sqlalchemy install
SQL
1 vote219 views1 answer
T-SQL Alter the column data type
SQL
0 vote201 views1 answer
Sqlites studio red exclamation mark when poening databse
SQL
0 vote204 views1 answer
What is database username and password in mysqliconnect
SQL
0 vote225 views1 answer
Insert output identity
SQL
3 votes182 views3 answers
Concatenation in sql
SQL
24 votes190 views6 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
SQL
150 votes540 views10 answers
Grepper
SQL
0 vote173 views1 answer
Dnsmasq.conf location macos
SQL
9 votes212 views1 answer
Alter table column change data type to text mysql
SQL