Re: Sort Alogorithmus

Hi Josef

> I have a plsql-table and need to sort this table have anyone a
> alogorithmus ?
> i can't use the order by of sql statement !!!
>

algorithm depends on how and what you would like to sort.Please give an example how your table will look like.
 for instance : type la_rec_typ is record ( p pls_integer, l pls_integer, i pls_integer ) ; type la_table_typ is table of la_rec_typ index by binary_integer ;

  tab                   la_table_typ;

• implements BLUB Sort

  ---

  procedure sort_table( x in out la_table_typ ) is t binary_integer; -- temp. Person ce boolean := TRUE; -- Changed Elements Indikator begin while ce loop ce := FALSE; for i in 1..x.count-1 loop if (x(i+1).p > x(i).p) or (x(i+1).p = x(i).p and x(i+1).l > x(i).l) then t:=x(i).p; x(i).p:=x(i+1).p; x(i+1).p:=t; t:=x(i).i; x(i).i:=x(i+1).i; x(i+1).i:=t; t:=x(i).l; x(i).l:=x(i+1).l; x(i+1).l:=t; ce:=TRUE; end if; end loop; end loop; end;
• end blub Sort

  ---

--