3.2.0

Ordering the values of a varchar2 datatype(Oracle)

Hi everybody,
I've a problem of sorting/ordering the values of a varchar2 datatype.
ex.
SQL> select * from test
2 order by project_line;
PROJECT_LINE
--------------------
29/10
29/10-15
29/100
29/100-15
29/50
30/10
value '29/50' shoud have to appear on the 3rd row and not on the 5th.
I'm using Oracle 9i, ver. 9.2.0.5.0
Can anybody help me out.
Thanks in advance,
Bekele, Amsterdam
Bekele
January 18,
No response necessary. (already solved by one of my colleagues with a
combination of decode and replace function).


Bekele
January 22,

This topic is archived.

See also:


Back to support forum