Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> quicksort

quicksort

From: Mark C. Wilhelm <mwilhelm_at_ccat.sas.upenn.edu>
Date: 11 Sep 1998 14:59:18 GMT
Message-ID: <6tbds6$g2g$1@netnews.upenn.edu>


I am looking to sort a PL/SQL table composed of programmer-defined records. I want to sort by one field in the record. I looked in the manuals for a sorting utility for PL/SQL tables but could not find one. So instead I tried to port over some already written C++ code of the quicksort algorithm into PL/SQL, but I am not having much luck with that either.

I'm using Oracle version and PL/SQL release 8.0.4.0.0.

Just wondering if anyone knows of any quick-and-dirty sorting strategies that I could "borrow" (steal).

If all else fails I am sure I could get crappy old bubblesort to do the job.

Thanks.

 --


Mark Wilhelm			|	(57)3-7418
Web Programmer			|	mwilhelm_at_ccat.sas.upenn.edu
Instructional Computing,	|	ccat.sas.upenn.edu/~mwilhelm
School of Arts And Sciences	|
University of Pennsylvania	|

===================================================================
Received on Fri Sep 11 1998 - 09:59:18 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US