declare
i number;
...
begin
...
open c_city( pc1.arb_ord_nr, pc1.arb_ord_zae );
loop
fetch c_city into pCity;
exit when c_city%notfound;
for i in 1..pCity.quantity loop
/* -- add one label per city cursor row */
insert into labels
( sessionid, arb_ord_nr, c_number, tl_fam, tl_atn, c_type, dat_neu )
values
( sid, pCity.arb_ord_nr, i, null, null, sType, sysdate );
commit;
end loop;
end loop;
close c_city;
Microsoft AX 2012, X++, C#, SQL server, SSRS, Java, JavaFX, Oracle, PL/SQL, Delphi - codes examples, step-by-step tutorials, experiences.
Tuesday, January 23, 2018
ORACLE - "for" statement in PL/SQL
Easy for loop for labels generation:
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment