Consider the below PL/SQL code to display employee details of department 20. What will be the result after executing this code?

DECLARE
  CURSOR cur_emp_in_dept
  IS
    SELECT employee_id,salary,hire_date FROM employees WHERE department_id=20 ;
  v_emp_id employees.employee_id%TYPE;
  v_salary employees.salary%TYPE;
  v_hire_date employees.hire_date%TYPE;
BEGIN
   OPEN cur_emp_in_dept;
  LOOP
    FETCH cur_emp_in_dept INTO v_emp_id,v_salary,v_hire_date;
     EXIT
  WHEN cur_emp_in_dept%NOTFOUND;
    DBMS_OUTPUT.put_line ('Employee ID: ' || v_emp_id);
    DBMS_OUTPUT.put_line ('Salary: ' || v_salary);
    DBMS_OUTPUT.put_line ('Joining date: ' || v_hire_date);
  END LOOP;
  CLOSE cur_emp_in_dept;
   DBMS_OUTPUT.put_line ('RowCount: '||cur_emp_in_dept%rowcount);
END;

 

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