Directly on the SQL code:
Declare begin forCinch(SelectS_personinfo.nextval asSeq fromdual) LoopInsert intoTbpersoninfo (Ipersoninfoid,vcpersoncard,vcpassword,vcpersonname,vcpersionsex)Values(C.seq,'33000021','123456','Xiao Ming','male',); ifC.seq=C.seq+ - Then return ; End if; EndLoop;End;
Use the loop execution SQL in your own project as follows:
Declare begin forCinch(SelectTsa. Year, Tsa.weeknumber,tsa.owner fromTr_schedule_affair Tsa,to_horizon_user ThuwhereTsa.owner=Thu.id andThu.login_name='SH1' Group byTsa. Year, Tsa.weeknumber,tsa.owner) loopUpdate(Select * fromTr_schedule_affairwhere Year =C. Year andWeekNumber=C.weeknumber andowner=C.ownerOrder bystart_time) TSetstart_time=To_char (To_date (t.start_time)+7,'YYYY-MM-DD Hh24:mi'), End_time=To_char (To_date (t.end_time)+7,'YYYY-MM-DD Hh24:mi'), Year =To_char ((SelectStart_time from(Select * fromTr_schedule_affairwhere Year =C. Year andWeekNumber=C.weeknumber andowner=C.ownerOrder byStart_time)whereRowNum=1),'yyyy'), Month =To_char ((SelectStart_time from(Select * fromTr_schedule_affairwhere Year =C. Year andWeekNumber=C.weeknumber andowner=C.ownerOrder byStart_time)whereRowNum=1),'mm'), WeekNumber=C.weeknumber+1; EndLoop;End;
Oracle Loop statements