Oracle Sql 循环
Declare
Lcntr number;
Begin
FOR Lcntr IN 1..5
LOOP
DBMS_OUTPUT.PUT_LINE('Lcntr='||Lcntr);
END LOOP;
end;
Begin
FOR REC_INIT IN (select HZ_NAME from HZ) LOOP
DBMS_OUTPUT.PUT_LINE(hz='||REC_INIT.ID);
END LOOP;
end;