【SQL开源代码栏目提醒】:网学会员SQL开源代码为您提供for_loop_end1.sql参考,解决您在for_loop_end1.sql学习中工作中的难题,参考学习。
DECLARE
CURSOR c1 IS SELECT * FROM emp FOR UPDATE OF sal;
BEGIN
FOR i IN c1
LOOP
IF (i.sal+i.sal*0.1)<=5000 THEN
UPDATE emp SET sal=sal+sal*0.1 WHERE CURRENT OF c1;
DBMS_OUTPUT.PUT_LINE(i.sal);
END IF;
END LOOP;
END;
/