Consider the package, pkg_add_number, both specifications and body that contains functions for adding numbers.

CREATE OR REPLACE PACKAGE pkg_add_number
IS
  FUNCTION add_numbers(p_num1 NUMBER,p_num2 NUMBER) RETURN NUMBER;
  FUNCTION add_numbers(p_num1 NUMBER, p_num2 NUMBER, p_num3 NUMBER) RETURN NUMBER;
  FUNCTION add_numbers( p_num1 NUMBER, p_num2 VARCHAR2 DEFAULT 70) RETURN NUMBER;
END pkg_add_number;

CREATE OR REPLACE PACKAGE BODY pkg_add_number
IS
  FUNCTION add_numbers( p_num1 NUMBER,p_num2 NUMBER) 
    RETURN NUMBER
  IS
    v_sum NUMBER(5);
  BEGIN
    v_sum:=p_num1+p_num2;
    RETURN v_sum;
  END add_numbers;
  
  FUNCTION add_numbers(p_num1 NUMBER,p_num2 NUMBER,p_num3 NUMBER)
    RETURN NUMBER
  IS
    v_sum NUMBER(5);
  BEGIN
    v_sum:=p_num1+p_num2+p_num3;
    RETURN v_sum;
  END add_numbers;
  
  FUNCTION add_numbers(p_num1 NUMBER,p_num2 VARCHAR2 DEFAULT 70)
    RETURN NUMBER
  IS
    v_sum NUMBER;
  BEGIN
    v_sum:=p_num1+to_number(p_num2);
    RETURN v_sum;
  END add_numbers;
  
END pkg_add_number;

What will be the output on executing the below PL/SQL code?

DECLARE
  v_sum NUMBER;
BEGIN
  v_sum:=pkg_add_number.add_numbers(10,'90');
  DBMS_OUTPUT.PUT_LINE('Sum is '||v_sum);
END;

 

To get all PLSQL Assessment Exam questions Join Telegram Group https://bit.ly/infy_premium_group