Oracle 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

5 votes335 views4 answers
Sqlite3.OperationalError: near "WHERE": syntax error
SQL
0 vote302 views1 answer
Sql query for select from specific columns in a table
SQL
0 vote304 views1 answer
Importerror no module named mysql.connector raspberry pi
SQL
0 vote436 views1 answer
What URL will take me directly to Rudolph's Reddit comment history?
SQL
-1 vote326 views1 answer
Search all database tables for a value sqlserver
SQL
0 vote310 views1 answer
Systemverilog unique constraint unique values
SQL
1 vote355 views1 answer
Insert many to many sql
SQL
0 vote356 views1 answer
How to create notes in mysql
SQL
0 vote357 views2 answers
Amazon linux postgresql client
SQL
0 vote317 views1 answer
Sql grant select only
SQL