Write a PL/SQL procedure to calculate the incentive achieved according to the specific sale limit
- pl/sql
- 2021-09-26
- mhanasmh00489829403
الأجوبة
DECLARE
PROCEDURE test1 (sal_achieve NUMBER)
IS
incentive NUMBER := 0;
BEGIN
IF sal_achieve > 44000 THEN
incentive := 1800;
ELSIF sal_achieve > 32000 THEN
incentive := 800;
ELSE
incentive := 500;
END IF;
DBMS_OUTPUT.NEW_LINE;
DBMS_OUTPUT.PUT_LINE (
'Sale achieved : ' || sal_achieve || ', incentive : ' || incentive || '.'
);
END test1;
BEGIN
test1(45000);
test1(36000);
test1(28000);
END;
/Sample Output:
Sale achieved : 45000, incentive : 1800. Sale achieved : 36000, incentive : 800. Sale achieved : 28000, incentive : 500. PL/SQL procedure successfully completed.
أسئلة مشابهة
القوائم الدراسية التي ينتمي لها السؤال
معلومات ذات صلة