Re: Getting the View code

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 12 May 1999 23:34:31 +0200
Message-ID: <926544749.5502.0.pluto.d4ee154e@news.demon.nl>

Hi Greg
In sqlplus set long 1000 or 2000 or whatever is long enough...

Hth,

Sybrand Bakker, Oracle DBA

lechkung > @detroitedison.com> <"lechkung< wrote in message <3739EABD.B3464AD6_at_detroitedison.com>...
>I'm trying to get the source code for a view that I have set up in my
>database. When I try to select it get only the first line of the view:
>
>select * from dba_views where view_name = 'CIL_CURRENT_VIEW'
>
>Owner View_name Text_length Text
>===== ================= ========== ====================
>CIL CIL_CURRENT_VIEW 4484 SELECT
>
>I know that there is more to the TEXT column, but I can't remember what
>environment setting that controls the listing of the column (if that's
>the problem).
>
>Can someone give me a hint?
>
>Thanks in advance,
>Greg Lechkun
>lechkung<remove>@tir.com
>
Received on Wed May 12 1999 - 16:34:31 CDT