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.
All IT and Non IT Interview Questions, MCQs, Online Quiz Questions, Engineering VIVA Questions
Home » Unlabelled » 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.
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.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment