Re: own order by

You could create a function which returns the order based on the your fld and order by that function

eg ORDER BY my_order(my_fld)

• rajXesh

"Wolf" <a912165390_at_aon.at> wrote in message news:<3d29c99a$0$33062$91cee783_at_newsreader02.highway.telekom.at>...
> Is there a way to tell oracle how the "order by" clause orders
> the database entries. (except asc, desc).
> Example:
> I want to sort VARCHAR2 Fields but no by alphabetical order.
> So I want to define that X is the first letter and F ist the second letter
> in order and so on...
>
> Wolf
Received on Tue Jul 09 2002 - 08:43:44 CDT