Write a PL/SQL block to calculate the incentive of an employee whose ID is 110
- pl/sql
- 2021-09-26
- mhanasmh00489829403
الأجوبة
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
أسئلة مشابهة
القوائم الدراسية التي ينتمي لها السؤال
معلومات ذات صلة