Re: formatting output with SQL*Plus

On 09.12.2004 16:57 DA Morgan wrote:

> You are correct. If the format you want is field concatenated to a
> single vertical bar concatenated to a field then the answer has been
> previously provided to you:
>
> SELECT column_name || '|' || column_name
> FROM ...
>
> If that is not what you want please restate your request.

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"

I have 26 columns each of them defined as VARCHAR2(2000) (don't ask why...)

Regards
Thomas Received on Thu Dec 09 2004 - 10:02:57 CST