Write a PL/SQL block to calculate the incentive of an employee whose ID is 110

hamza

Save to bookmark

2022-05-18

791

Write a PL/SQL block to calculate the incentive of an employee whose ID is 110.

The following PL/SQL block shows a veriable incentive have been declared and incentive have assigned into this variable.

pl/sql,

All Answers

hamza

2022-05-18

need an explanation for this answer? contact us directly to get an explanation for this answer

DECLARE
  incentive   NUMBER(8,2);
BEGIN
  SELECT salary * 0.12 INTO incentive
  FROM employees
  WHERE employee_id = 110;
DBMS_OUTPUT.PUT_LINE('Incentive  = ' || TO_CHAR(incentive));
END;
/

Sample Output:

Incentive  = 984

Statement processed.

0.00 seconds

need an explanation for this answer? contact us directly to get an explanation for this answer

total answers (1)

Write a PL/SQL block to calculate the incentive of an employee whose ID is 110

All Answers

Similar questions

need a help?

find thousands of online teachers now