Re: truncated output from simple select stmt...

From: Peter van Rijn <pgm.van.rijn-hahaha_at_hccnet.nl>
Date: Wed, 14 Aug 2002 22:04:38 +0200
Message-ID: <ajed0r$e6b$1@news.hccnet.nl>

If I remember well the TEXT column is a LONG. Which means you'll have to do something like:

SQL> set long 2048

or whatever size is appropriate. It defaults to 80, and that's why you only see a small part of the text.

hth,
Peter

"mick" <m_protopapas_at_hotmail.com> schreef in bericht news:774a0292.0208141034.a69aa87_at_posting.google.com...
> Hello all,
>
> Using 8.1.7 on Win2kPro sp3. I don't understand why the output in the
TEXT
> column is truncated. I don't have any formatting applied to the column...
>
> Any assistance is appreciated.
>
> hr_at_DEMODB> CLEAR COLUMNS
> columns cleared
>
> hr_at_DEMODB> select text, text_length
> 2 from user_views
> 3 where view_name='COMPANY_PHONE_BOOK';
>
> TEXT TEXT_LENGTH
> -------------------------------------^^---------------------- -----------
> SELECT employee_id, 99
> last_name || ', '|| first_name name,
> phone_number, em
>
> ^
> | why the truncation??
Received on Wed Aug 14 2002 - 15:04:38 CDT