Re: View SQL code
From: Greg Dora <gnd_at_flinet.com>
Date: 1996/02/24
Message-ID: <4glqg5$3s0_at_news.flinet.com>#1/1
Date: 1996/02/24
Message-ID: <4glqg5$3s0_at_news.flinet.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.
:
REM the TEXT column is a long, and longs truncate at 80 by default.
set long 32000
select TEXT from all_views where <view_name> = VIEW_NAME;
Received on Sat Feb 24 1996 - 00:00:00 CET