PL/SQL PROCEDURE DATA

PHOTO EMBED

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