Package Specification dept_pack was created by the following…
Package Specification dept_pack was created by the following code: CREATE OR REPLACE PACKAGE dept_pack IS PROCEDURE ins_dept(p_deptno IN NUMBER); FUNCTION get_dept(p_deptno IN NUMBER) RETURN VARCHAR2;END dept_pack; Which of the following is incorrect syntax for invoking the package subprograms?
Read DetailsThe following PL/SQL block will correctly return the last na…
The following PL/SQL block will correctly return the last name of the employee whose employee id is 100. True or False? DECLARE v_last_name employees.last_name%TYPE; employee_id employees.employee_id%TYPE := 100; BEGIN SELECT last_name INTO v_last_name FROM employees WHERE employee_id = employee_id; END;
Read Details