PL/SQL questions for experiece developper on a simple problem with tables...
From: <smenard_at_avcorp.com>
Date: Thu, 18 Jul 2002 16:21:54 -0400
Message-ID: <20020718.162154.387451659.22573_at_avcorp.com>
[Quoted] My Problem...
}
Date: Thu, 18 Jul 2002 16:21:54 -0400
Message-ID: <20020718.162154.387451659.22573_at_avcorp.com>
[Quoted] My Problem...
i have a type...
TYPE qty IS RECORD
{
date_rec date, ctrl item_specification.ctrl_spec_id%type, type_ent varchar2(3), ref_ent varchar2(30), ref_item varchar2(30), qty_ent number
}
TYPE qty_table is table of qty index by binary_integer;
i have 4 procedure that return a list of TYPE qty_table....
builpolist(part number,list qty_table );
buildsolist(part number,list2 qty_table ); buildwolist(part number, list3 qty_table); buildrelist(part number, list4 qty_table);
i want to take the 4 list to create a list list5 sort by date (list5(i).date_rec....)
what is the best way to do that?
sql/table! temporary table? collection?
ths! Received on Thu Jul 18 2002 - 22:21:54 CEST