Re: Help: Sorting a PL/SQL table

If possible, while loading the PL/SQL table itself, you may want to store the records in sorted order. If it is not possible, I am afraid, you will have to write your own sort routine.

CM

In article <6gogv3$f5j$1_at_nnrp1.dejanews.com>,   pradeepj_at_hotmail.com wrote:
>
> does this mean you want to sort records in your table in a specific manner,
> or in other words do you want to sort some columns of the tble in a
> particular fashion ? if you want to sort a particular set of columns I
> suppose ORDER BY should help.
>
> In article <352CEDB0.B8F205CE_at_infoaccess.dk>,
> Casper Thrane <ct_at_infoaccess.dk> wrote:
> >
> > Hi!
> >
> > I have created a PL/SQL tables that contains 10 columns, but now I want
> > to sort my table.
> > I have tried using SQL, but then I get an error.
> > How can I sort my table?
> > --
> > Casper Thrane
> > InfoAccess
> >
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/ Now offering spam-free web-based newsreading
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Mon Apr 13 1998 - 12:20:17 CDT