Re: "Absoulte" sorting?
From: Barry Roomberg <barry_roomberg_at_iacnet.com>
Date: 1995/05/09
Message-ID: <D8BJt8.B3x_at_zcias2.ziff.com>#1/1
Date: 1995/05/09
Message-ID: <D8BJt8.B3x_at_zcias2.ziff.com>#1/1
In article <D886zD.MLA_at_dorsai.org>, vkwan_at_news.dorsai.org (Vito Kwan) says:
>
>Hi all,
> I have a question about Oracle sorting. Say I have a colume with
>varchar2 data type, and there are 3 rows under it. They are
>abc11
>abc2
>abc123
>
>After sorting, Oracle gives
>abc11
>abc123
>abc2
>
>Is there a way to sort the colume and makes it
>abc2
>abc11
>abc123
>
>I know I can solve the problem by putting the leading 0, but unfortunately,
>our clients don't want that.
>Any help will be appreciated.
>
Create a hidden column that contains the "correct" sort key, and have your app maintain it (possibly through a trigger) Received on Tue May 09 1995 - 00:00:00 CEST