Re: View SQL code

From: Tony Damon <bfntd_at_aimnet.com>
Date: 1996/02/22
Message-ID: <4gi3rl$2gv_at_news2.aimnet.com>#1/1


raz_at_opus.freac.fsu.edu wrote:
: Hello,
:
: A previous employee created a View which is used by a couple of programs.
: The view was not documented and we need to see what's the SQL code of the
: view.
:
: How can I view this code? A describe <view_name> only shows the fields
: of the view. I need to see the actual SQL code.
:

Try select * from user_views or select * from dba_views.

Tony Damon Received on Thu Feb 22 1996 - 00:00:00 CET

Original text of this message