Sort PL/SQL Table

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