PL/SQL PROCEDURE DATA
Fri Aug 11 2023 09:56:44 GMT+0000 (Coordinated Universal Time)
Saved by
@austin
DECLARE
PROCEDURE p (sales NUMBER)
IS
bonus NUMBER := 20;
BEGIN
IF sales > 50000 THEN
bonus := 1500;
ELSIF sales > 35000 THEN
bonus := 500;
ELSE
bonus := 100;
END IF;
DBMS_OUTPUT.PUT_LINE (
'Sales = ' || sales || ', bonus = ' || bonus || '.'
);
END p;
BEGIN
p(100);
p(100);
p(100);
END;
content_copyCOPY
Comments