Re: formatting output with SQL*Plus

"Thomas Kellerer" <NNGNVRDSJEBN_at_spammotel.com> wrote in message news:cp7kmh$l1u$1_at_svr7.m-online.net...
> Alan wrote on 08.12.2004 20:22:
>>
>> SELECT column1||'|'||column2 etc...
>>
>> Get rid of SET COLSEP
>>
>
> As I have already pointed out in my original post: I get the following
> error when doing so:
> "ORA-01489: result of string concatenation is too long"
>
> Thanks
> Thomas

set colsep
set trimspool on Received on Wed Dec 08 2004 - 13:53:44 CST