DECLARE
x NUMBER := 0;
iSalary Number;
iAllowance Number;
BEGIN
iSalary := 585.90;
iAllowance := 58.59;
LOOP
x := x+1;
INSERT INTO EmployeeTab (BasicSalary)
select CASE WHEN GL = 'L'||x THEN 23 + (iSalary*(x-1)) END
FROM EmployeeTab;
INSERT INTO EmployeeTab (BasicAllowance)
select CASE WHEN GL = 'M'||x THEN 32 + (iAllowance*(x-1)) END
FROM EmployeeTab;
IF x > 14 THEN
EXIT;
END IF;
END LOOP;
END;