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

From: dbyy <noname_at_fooled.com>
Date: Thu, 11 Nov 2004 04:42:46 GMT
Message-ID: <Xns959DF1391DC27dbyyatcanadadotcomni@207.35.177.134>

yf110_at_vtn1.victoria.tc.ca (Malcolm Dew-Jones) wrote in news:41916ea9_at_news.victoria.tc.ca:

> dbyy (noname_at_fooled.com) 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?

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

Thank you all kind souls who were trying to help me. In the meantime I wrote my own SQL code that is doing the same then the Clipper func DESCEND.

Cheers
Fred Received on Wed Nov 10 2004 - 22:42:46 CST