Re: DESC() -func- in Oracle 9i

From: dbyy <noname_at_fooled.com>
Date: Tue, 09 Nov 2004 22:49:08 GMT
Message-ID: <Xns959CB52AF7989dbyyatcanadadotcomni@207.35.177.134>

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 Received on Tue Nov 09 2004 - 16:49:08 CST