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

2 votes165 views1 answer
Select sid oracle
SQL
0 vote191 views1 answer
Sqlalchemy.exc.DBAPIError: (ibm_db_dbi.Error) ibm_db_dbi::Error: SystemError('<built-in function connect> returned NULL without setting an error')
SQL
6 votes199 views2 answers
Mysql set primary key
SQL
0 vote220 views1 answer
Mariadb set vertical output format
SQL
0 vote218 views1 answer
Day of the week sqlite
SQL
3 votes196 views1 answer
Oracle failed login attempts
SQL
5 votes205 views1 answer
Sql check if date is between 2 dates
SQL
0 vote203 views1 answer
Sql put two columns into one
SQL
0 vote197 views4 answers
Best data type to represent money in mysql
SQL
1 vote200 views4 answers
Psql check tables command
SQL