Re: SQL Plus32 Display of Long Format Columns?

On Sun, 22 Sep 1996, Hagen Finley 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
>
>
Hagen, I think all you need to do is at the SQL Plus prompt change the default value displayed for LONG to however "long" you need it to be.

For example,

SET LONG 300 if you wanted the first 300 characters displayed for your column. I think the default is 80, so that would explain why you couldn't get it to work. I know SET LONG works for me on 7.2, YMMV.

HTH, John Received on Tue Sep 24 1996 - 00:00:00 CEST