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