Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Usenet -> c.d.o.misc -> Re: DESC() -func- in Oracle 9i

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

From: Malcolm Dew-Jones <>
Date: 9 Nov 2004 17:28:09 -0800
Message-ID: <>

dbyy ( wrote:
: (Malcolm Dew-Jones) wrote in

: > 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.
: >
: > 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?

Oracle has many _f_u_n_c_t_i_o_n_s_ - I would not assume the name assigned to a function within Clipper is the same as the name of a functionally equivalent function available in Oracle.

Obviously you need to choose the one that performs the same task as the Clipper function called DESCEND().

However, since I am not a Clipper programmer, I have no idea exactly what the Clipper DESCEND() function does. Therefore I cannot tell you which oracle function to use - unless I understand what it is you are trying to accomplish.

Unfortunately I have no idea from your desciption exactly what you are trying to accomplish. Received on Tue Nov 09 2004 - 19:28:09 CST

Original text of this message