Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle will ignore positions 1000 and after in a string field or expression for sorting using an ORDER BY clause.

Re: Oracle will ignore positions 1000 and after in a string field or expression for sorting using an ORDER BY clause.

From: Noel <tbal_at_go2.pll-l>
Date: Thu, 13 Jan 2005 14:03:18 +0100
Message-ID: <cs5rqa$pqj$1@atlantis.news.tpi.pl>


Użytkownik Roel Schreurs napisał:

> (In case you were wondering why I would like to sort string that
> differ so little, I construct a long string of descriptions of all
> ancestors in an hierarchic query to sort siblings on that
> description.)

Very, very strange. We must live with that until Oracle won't solve it. To solve it i write such a quieries:

select num,substr(val,998), substr(val,999) from test_order_by
--order by val, num desc
--order by substr(val,1,999), substr(val,999), num desc

Uncomment second order please, works well.

-- 
Noel
Received on Thu Jan 13 2005 - 07:03:18 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US