Consider the following PL/SQL code querying HR database for computing incentive for a given employee: DECLARE...

Transcribed Image Text:

Consider the following PL/SQL code querying HR database for computing incentive for a given employee: DECLARE incentive v_last_name BEGIN ; END; ; SELECT salary 0.12, last_name INTO incentive, v_lastname FROM employees WHERE employee_id = 110; DBMS_OUTPUT.PUT_LINE('Incentive = ' || TO_CHAR(incentive)); Answer the following using appropriate PL/SQL statements. a) What should be the data type of variables 'incentive' and 'v_last_name' for above code to execute successfully? [2 marks] b) Modify the code to handle the exception by printing " No employee <employee id> exists in the database" in case no rows with employee id=110 exist in the table. Consider the following PL/SQL code querying HR database for computing incentive for a given employee: DECLARE incentive v_last_name BEGIN ; END; ; SELECT salary 0.12, last_name INTO incentive, v_lastname FROM employees WHERE employee_id = 110; DBMS_OUTPUT.PUT_LINE('Incentive = ' || TO_CHAR(incentive)); Answer the following using appropriate PL/SQL statements. a) What should be the data type of variables 'incentive' and 'v_last_name' for above code to execute successfully? [2 marks] b) Modify the code to handle the exception by printing " No employee <employee id> exists in the database" in case no rows with employee id=110 exist in the table.

Answer rating: 100% (QA)

a What should be the data type of variables incentive and vlastname for above code to execute succes... View the full answer