Re: Using Generic Comparator in Oracle ORDER BY

Yes, I understand what you are saying. Basically you want to duplicate the Java compare capability on arbitrary object. Which, since Java is available in the database, should be possible IF you can actually define comparison. (Seems like overkill to me, though, as a compensation for a popular, albeit IMO generally stupid, AIN scheme.)

However, you STILL miss my point. I suggest creating a function that returns some hash value which implies a numeric ordering. I don't depend on simple lexical ordering or stored value, but rather a derived lexical ordering.

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** I no longer assist with top-posted newsgroup queries ***