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

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? Received on Sat Nov 06 2004 - 16:02:09 CST