Oracle view source

-- 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 vote257 views1 answer
Select distinct after join
SQL
1 vote253 views1 answer
Select users with same username
SQL
0 vote230 views1 answer
How to to get current date in sql
SQL
22 votes239 views3 answers
Remove all records from table mysql
SQL
1 vote218 views1 answer
Get the User Name and Domain Name from an Email Address
SQL
0 vote235 views1 answer
Renommer base sql
SQL
15 votes327 views5 answers
Select all tables sql
SQL
0 vote218 views1 answer
AddEntityFrameworkSqlite
SQL
1 vote193 views1 answer
Database run
SQL
1 vote237 views2 answers
Sqlstate[hy000]: general error: 1005 can't create table (errno: 150 "foreign key constraint is incorrectly formed")
SQL