dbyy wrote:
> Bricklen <bricklen_at_zyahoo.zcomz> wrote in
> news:%Xxid.76946$df2.56571_at_edtnps89:
>
>
>>dbyy wrote:
>>
>>>hi everyone,
>>>
>>>I have the following situation:
>>>We're converting an existing database (Clipper DBF tables) with
>>>several Clipper and DELPHI applications to Oracle 9i using Mediator
>>>by OTC.
>>>
>>>On couple of tables we have a column which is a column with a
>>>combined index field from the old table (I know this is not data
>>>normalization) e.g. <XXXXXYYYYYZZZZZ> - (VarcHar15).
>>>One of this values (ZZZZZ) is in the original DBF table in DESCENDing
>>>order converted by a Clipper function DESCEND().
>>>
>>>My question is, is there a DESC() function available in Oracle which
>>>can do the same trick in a sp/trigger then the clipper function did.
>>>
>>>I know there is a choice to create an index on a column in DESC
>>>order. But I think that is not the solution for me because not a full
>>>column value must be in DESC order, only a part of the value.
>>>
>>>Please don't tear me apart, I know this is not the way how a rdbms
>>>should be designed, but this is the situation I hve to live with it.
>>>
>>>Thanks in advance for any posting.
>>>
>>>Regards
>>>Fred
>>
>>Look into Function Based Indexes (FBI) to index those substrings.
>>That's
>> the only way that I can think of off-hand.
>>
>>Oracle docs: tahiti.oracle.com
>>Oracle guru: asktom.oracle.com
>>
>
>
> Thanks for the info.
> Thats what I think too. That this is a FBI on the table.
> But is a func DESC() available in Oracle? In some of the standard
> packages migth be?
>
> TIA
> Fred
Hm - isn't select .... from ... order by .... descending
what you want?!? Or select substr(your_varchar15 here,10,5),
order by substr(your_varchar15 here,10,5) ?
--
Regards,
Frank van Bortel
Received on Sun Nov 07 2004 - 15:13:51 CST
