OraFAQ Forum: SQL & PL/SQL » How can I see the SQL used to create a View?

Home » SQL & PL/SQL » SQL & PL/SQL » How can I see the SQL used to create a View?

Mon, 01 April 2002 06:45

servando
Messages: 2
Registered: April 2002

Junior Member

How can I see the SQL code used to create a View?

Mon, 01 April 2002 07:05

Cindy
Messages: 88
Registered: November 1999

Member

select view_name, text from all_views where view_name = 'VIEW_NAME';

Also, you can also use dba_views and user_views tables.

Previous Topic:	sql command
Next Topic:	ABOUT PROCEDURE

Goto Forum:

]

Current Time: Fri Apr 19 09:02:43 CDT 2024