Re: order behaviour ?

From: Gildas COTOMALE <gcotomale_at_kleegroup.fr>
Date: Thu, 7 Jun 2001 11:08:46 +0200
Message-ID: <9fng4m$tks$1@klin.lan.klee.fr>

"hannes achleitner" <hannes_a_at_hotmail.com> a écrit dans le message news: 3B1F341D.E5B9484B_at_hotmail.com...
> how can I change order behaviour in 8.1.6 ?
> with the command 'select col from table order by col' I like to recive
> number befor character
> col
> ---
> 1
> 2
> a
> A
> b
> B
>
> is this possible and how to change ?
> thx
> hannes
>

Ordering is base on your NLS parameters... Received on Thu Jun 07 2001 - 04:08:46 CDT

This message: [ Message body ]
Next message: hannes achleitner: "Re: order behaviour ?"
Previous message: hannes achleitner: "order behaviour ?"
In reply to: hannes achleitner: "order behaviour ?"
Next in thread: hannes achleitner: "Re: order behaviour ?"
Reply: hannes achleitner: "Re: order behaviour ?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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