Change sorting behaviour?

From: Andreas Koch <mail_at_kochandreas.com>
Date: Thu, 25 Apr 2002 19:23:23 +0200
Message-ID: <aa9e2p$m1h$04$1@news.t-online.com>

Hi,

is there a way to make oracle sort a varchar column in Format TextNumber
(e.g. Example01, Data42, etc) allways as "Text as Text and
Number as Number" ?
(e.g

Data1
Data2
Data9
Data10
Error1
Error5

instead of

Data1
Data10
Data2
Data9
Error1
Error5
)

If this can't be done per connection, what would be the best way to modify a SQL to sort this way?

-- 
                                                   Andreas
if ((sex==fem)&&(hobby==comp)&&(age~25)&&(status==single)
&&(cntry=GER)) goto http://www.kochandreas.com/home/single.htm

Received on Thu Apr 25 2002 - 12:23:23 CDT