Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Sorting ANYDATA types
Troy wrote:
> Hi-
>
> I have a need to use an ANYDATA type. Is it possible to sort columns
> with ANYDATA types if the objects contained therein implement the map
> and order functions? I cannot find any info on this.
>
> Thanks-
> Troy
What do you expect a sort to accomplish? What if the values are mixed VARCHAR2, NUMBER, and DATE? Where does 01-JAN-2004 sort to? How about 01/01/2004?
You can always sort ... but you will need to have a sort definition that is logically consistent.
-- Daniel Morgan http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp damorgan_at_x.washington.edu (replace 'x' with a 'u' to reply)Received on Thu May 13 2004 - 22:32:16 CDT