Problem with Oracle/SQL ORDER BY Statement

Posted by ArneRie on Stack Overflow See other posts from Stack Overflow or by ArneRie
Published on 2010-05-17T12:29:57Z Indexed on 2010/05/17 12:30 UTC
Read the original article Hit count: 240

Filed under:
|

Hi,

i have the following content inside an varchar2 column:

   10.1.2.3
   10.2.3.4
   8.3.4.1
   8.3.2.1
   4.2.1.3
   4.3.2.1
   9.3.1.2

When i query the database i need an result ordered:

4....
8....
9....
10...

the NLS_SORT parameter is set to german, an simple "order by COLUMN DESC/ASC" is not working like excepted. It returns

10.....
8......
9......

any suggestions?

© Stack Overflow or respective owner

Related posts about Oracle

Related posts about sql