Re: SQL Plus32 Display of Long Format Columns?
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