Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Problem in SQL....??
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...
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
Received on Thu Oct 28 1999 - 16:49:12 CDT