DECLARE PROCEDURE p ( sales NUMBER, quota NUMBER, emp_id NUMBER ) IS bonus NUMBER := 0; updated VARCHAR2(3) := 'No'; BEGIN IF sales > (quota + 200) THEN bonus := (sales - quota)/4; UPDATE employees SET salary = salary + bonus WHERE employee_id = emp_id; updated := 'Yes'; END IF; DBMS_OUTPUT.PUT_LINE ( 'Table updated? ' || updated || ', ' || 'bonus = ' || bonus || '.' ); END p; sales_val NUMBER; quota_val NUMBER; emp_id_val NUMBER; BEGIN -- Retrieve values from the sales_data table SELECT sales, quota, emp_id INTO sales_val, quota_val, emp_id_val FROM sales_data WHERE some_condition; -- Adjust the condition based on your needs -- Call the procedure with the retrieved values p(sales_val, quota_val, emp_id_val); END;
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter