Re: SQL Plus32 Display of Long Format Columns?

From: Venkateswara R Polisetti <vrao_at_sctcorp.com>
Date: 1996/09/23
Message-ID: <1996Sep23.150215.8528_at_mcrcr6>#1/1


Hagen Finley <hagen_at_violet.berkeley.edu> wrote:

>I have several tables wherein I have LONG columns in which I have
>inputed text via a form created in Power Objects in the MULTI-LINE mode.
>When I SELECT those rows via SQL Plus32 I get the first line but none of
>the subsequent lines. By way of contrast, when I have used VARCHAR2
>instead of LONG, SQL Plus32 displays all of the multi-line columns
>properly. Is there a column format command that will force the LONG
>columns to display all the lines in the column?
> BTW, I have tried word_wrap and that did not seem to work, at least
>simply entering 'column TEXT word_wrap' did not produce the rest of the
>text in the column.
 

>Hagen Finley
>Berkeley, CA

Try

       SQL> set long <n>
By default it is set to 80. You can set <n> to any value not exceeding MAXDATA. Good luck,
Venkateswara Rao Received on Mon Sep 23 1996 - 00:00:00 CEST

Original text of this message