Tuesday, 22 May 2012

Suppose, emp_details is an explicit cursor and v_emp_dtls is a %ROWTYPE variable. Choose the correct FETCH statement from the following options. a. FETCH emp_details INTO v_emp_dtls.emp_code b. FETCH emp_details INTO v_emp_dtls%ROWTYPE c. FETCH v_emp_details INTO emp.dtls d. FETCH emp_details INTO v_emp_dtls.

  The correct answer is D because the cursor records are first fetched into the declared variable and then the variable is used further in the code.