dbyy wrote:
> yf110_at_vtn1.victoria.tc.ca (Malcolm Dew-Jones) wrote in
> news:418d49e1_at_news.victoria.tc.ca:
>
>
>>dbyy (noname_at_fooled.com) 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.
>>
>>The data isn't stored in any particular order in the oracle database,
>>so I am not sure you are asking the proper question.
>>
>>You can ask oracle to display the data in any order you wish,
>>including based on portions of a column or other more complex things.
>>
>>Do you need to efficiently find a row based on a key that is a portion
>>of a column?
>>
>>
>>
>
>
> Actually my question was:
> Is a DESC or DESCEND _f_u_n_c_t_i_o_n_ available on in Oracle 9i?
>
> I know the clause DESC can be used in ORDER BY or CREATE INDEX.
> But I have to use the DESC function in PL/SQL code.
>
> TIA
>
> Fred
Instead of assuming we have any idea what it is you are trying to do ...
we don't ... why don't you tell us rather than referring us to an
obscure product and its functionality?
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Thu Nov 11 2004 - 22:30:59 CST
