Re: Problem in SQL....??
Date: Fri, 29 Oct 1999 02:04:34 GMT
Message-ID: <7vavbh$roj$1_at_nnrp1.deja.com>
Hi Bhavesh,
You are right the size of string can be 32k, but when you use order by
clause the size of string can not be more then 2000(1990)to be more
precise.( this is what I recollect).
Cheer up
Arun
In article <3818C4D8.C6106385_at_Sun.COM>,
BHAVESH GOSAR <BHAVESH.GOSAR_at_Sun.COM> wrote:
> Hi,
>
> I have the foll. table
>
> Tab T1 ( x1 varchar2(8), x2 varchar2(2), x3 varcahr2(2),
> x4 number(38), x5 varchar2(2000)
> )
>
> When I do a...
>
> set linesize 2500
>
> select x1 || '~' || x2 || '~' || x3 || '~' || x4 || rtrim(x5) || '~'
> from t1
> order by x1, x2, x3, x4
>
> It gives the foll. error...
> =========
> ERROR:
> ORA-01489: result of string concatenation is too long
> =========
>
> When I remove the Order by Clause...
> It gets some rows and gives me the above error...
>
> I checked ORacle MAnuals...and it syas the MAximum length can be
> 32 KB for a string..
>
> Any Ideas...workaround...??
>
> Thanks,
> Bhavesh Gosar
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Fri Oct 29 1999 - 04:04:34 CEST