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
Received on Thu Nov 04 2004 - 19:04:52 CST
