Re: truncated output from simple select stmt...

Actually, found the cause...

Had to do with the LONG parameter
SQL> SHOW LONG
long 80
SQL> SET LONG 100 (or whatever length is necessary) SQL> SHOW LONG
long 100
...performed the same select that initially truncated and everything showed up.

All ok

m_protopapas_at_hotmail.com (mick) wrote in message 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

from user_views
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 - 17:09:47 CDT