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

0 vote360 views1 answer
SQLite3::SQLException: table "categories" already exists: CREATE TABLE "categories" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL
SQL
0 vote442 views1 answer
Sqlite send a query to a Sqlite DB with Ruby
SQL
1 vote371 views2 answers
Duplicate key value violates unique constraint "django_admin_log_pkey"
SQL
1 vote380 views1 answer
Round one decimal place mysql
SQL
1 vote340 views2 answers
Mysql type conversion
SQL
0 vote425 views1 answer
Why do we need data structure in sql
SQL
0 vote348 views1 answer
Match end of string regex sql
SQL
0 vote347 views1 answer
Select last N rows mysql
SQL
0 vote332 views1 answer
Allow all local clients (local socket connections) to connect to the kodekloud_db1
SQL
20 votes365 views3 answers
How to open postgresql in mac
SQL