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 -> Sort PL/SQL Table

Sort PL/SQL Table

From: <sirohimi_at_my-dejanews.com>
Date: Fri, 21 Aug 1998 12:01:10 GMT
Message-ID: <6rjni6$3vl$1@nnrp1.dejanews.com>


I need to sort a package defined PL/SQL table. I am populating the table by a CURSOR that has an age range that I am breaking down to its individual components of that age into the table. I am additionally storing other information in the table as well (It is a table of records).

My problem, I need to sort by age and the only way I can see doing this is by a bubble sort. I can possible have n^2 traversing in worst case. I have looked at many books and I cannot see that I have access to the pointers (so I am assuming that I cannot move the pointers of the table. Since the table is indexed by binary integers it may be treated as if it were an array or records. Does any one have a sorting algorithm they can share for accomplishing this? Any help is appreciated.

Thanks in advance,

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Fri Aug 21 1998 - 07:01:10 CDT

Original text of this message

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