Loop example
1)
SELECT NVL(ROUND(salary/1000), 0) INTO v_sal
FROM emp WHERE employee_id = v_empno;
FOR i IN 1…v_sal
LOOP
v_asterisk := v_asterisk ||’*’;
END LOOP;
UPDATE emp SET stars = v_asterisk
WHERE employee_id = v_empno;
COMMIT;
BEGIN
FOR i in 1…10 LOOP
IF i = 6 or i = 8 THEN
null;
ELSE
INSERT INTO messages(results)
VALUES (i);
END IF;
END LOOP;
COMMIT;
END;
/