View the Exhibit and examine the structure of the EMPLOYEES table. Examine the following PL/SQL block for storing the salary of all sales representatives from the EMPLOYEES table in an associative array:

1 DECLARE 2 emp_cv SYS_REFCURSOR; 3 TYPE list IS TABLE OF emp_cv; 4 sals list; 5 BEGIN 6 OPEN emp_cv FOR SELECT salary FROM employees 7 WHERE job_id = 'SA_REP'; 8 FETCH emp_cv BULK COLLECT INTO sals; 9 CLOSE emp_cv; 10 END; What should you correct in the above code to ensure that it executes successfully?

Question

View the Exhibit and examine the structure of the EMPLOYEES table. Examine the following PL/SQL block for storing the salary of all sales representatives from the EMPLOYEES table in an associative array:

1 DECLARE 2 emp_cv SYS_REFCURSOR; 3 TYPE list IS TABLE OF emp_cv; 4 sals list; 5 BEGIN 6 OPEN emp_cv FOR SELECT salary FROM employees 7 WHERE job_id = 'SA_REP'; 8 FETCH emp_cv BULK COLLECT INTO sals; 9 CLOSE emp_cv; 10 END; What should you correct in the above code to ensure that it executes successfully?

Accepted Answer

A. Replace EMP_CV in line 3 with employees.salary%TYPE.

Answer

B. Replace line 2 with TYPE refcur IS REF CURSOR; emp_cv refcur;.

Answer

C. Replace BULK COLLECT in line 8 with the OPEN, FETCH, LOOP, and CLOSE statements.

Answer

D. Replace line 2 with TYPE refcur IS REF CURSOR RETURN employees.salary%TYPE; emp_cv refcur;.

View the Exhibit and examine the structure of the EMPLOYEES table. Examine the following PL/SQL block for storing the salary of all sales representatives from the EMPLOYEES table in an associative…

Question

Exhibit

Options

How the community answered

Community Discussion