Re: Getting the whole text of my views
From: Johannes Wilhelm <x15_at_aixterm8.urz.uni-heidelberg.de>
Date: 26 Jun 1998 07:48:39 GMT
Message-ID: <6mvjon$j6e_at_sun0.urz.uni-heidelberg.de>
Date: 26 Jun 1998 07:48:39 GMT
Message-ID: <6mvjon$j6e_at_sun0.urz.uni-heidelberg.de>
Burkhard Schultheis <bschultheis_at_tde.ra.eunet.de> wrote:
> I wanted to see the text for a view of my own. Therefore I asked
> SQL*PLUS 'Select text from user_views where viewname = <view name>'. But
> in this way I get only the first 80 characters of the text. Linesize is
> at it's maximum of 32767, maxdata is set to it's maximum.
> So what to do to see the whole story?
Set the value for the SQL*PLUS variable "long" :
set long 4096
Johannes Wilhelm Received on Fri Jun 26 1998 - 09:48:39 CEST