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

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