Re: WORD WRAPPING IN VARCHAR2 STRINGS

From: Grue <grue_at_hotmail.com>
Date: 1998/01/12
Message-ID: <34ba84d3.25560027@128.158.254.10>#1/1

On 12 Jan 1998 20:36:41 GMT, "P Smith" <psmith_at_ppg.com> wrote:

>I have some varchar2(211) attributes which I wish to print on paper in a
>report. Is there a way to have word wrapping in SQLPLUS.
>
>Any advise will be appreciated
>--

You just need to format the column to specify the width that you want and use the WORD_WRAPPED clause. So, if you want to set the column width to 30 characters, you would do something like the following:

COLUMN column_name FORMAT A30 WORD_WRAPPED

Hope this helps.

Grue Received on Mon Jan 12 1998 - 00:00:00 CST