Iterate through a table in Oracle and update operations that meet the criteria

BEGIN forL_recordinch(SelectRecord_id,curr_period,period_start_date, (sysdate-Period_start_date) Difftime, (p.period_end_day-P.period_begin_day) Perioddiffday fromCps_patient_path_record T1Inner JoinCps_treat_period P onp.period_id=t1. Curr_periodwhereT1.path_state=1) LOOPIF(L_record. Difftime>=l_record.perioddiffday) Then         UPDATECps_patient_path_recordSETPeriod_start_date=To_date (To_char (Sysdate,'YYYY/MM/DD'),'YYYY/MM/DD'), Curr_period=L_record. Curr_period+1         WHERErecord_id=L_record.    record_id; END IF; ENDLOOP;END;

Format:

For record in (SELECT)

LOOP

UPDATE T WHERE

END LOOP

Iterate through a table in Oracle and update operations that meet the criteria