Oracle 11.2.0.4
Windows 64 bit
I have a requirement to load 30 items from each warehouse from stocks table and insert into transaction table.
I have 3 warehouses 02,03,04.
How do i select 30 items from each warehouse.
I tried the below query and i get 20 random records from different warehouse. i need 20 items from each warehouse.
cursor extractstock is
select pim_part_number, pim_part_desc,pim_warehouse
from perpetual_inventory_master
where PIM_POSTING_INITIALISED_DATE is null
and pim_warehouse in ('02','03','04')
order by pim_part_number asc;
begin
for c1 in extractstock loop
insert into perpetual_inventory_trnsaction(
pit_warehouse,
pit_extract_date,
pit_part_number,
pit_part_desc,
pit_stock_qty,
pit_unit_cost
)
values(
c1.pim_warehouse,
sysdate,
c1.pim_part_number,
c1.pim_part_desc,
e_qty,
e_unitcost
);
commit;
if nvl(totalcount,0) >= 20
then
exit;
end if;
end loop;
end if;
end;
Please suggest a workaround.