Oracle Database Advanced PL SQL 12c 1z0 148

Question : 24 of 54

Marks: +1, -0

Examine the structure of the EMP table:

Examine this code:

Which code should be inserted to display the collection contents?

1_indx := 1_list.FIRST; WHILE (1_indx IS NOT NULL) LOOP DBMS_OUTPUT.PUT_LINE (1_indx || ‘ ’ || 1_list (1_indx)); 1_indx := 1_emp.NEXT (1_indx); END LOOP;
FOR indx IN 1_list. COUNT .. -1 LOOP DBMS_OUTPUT.PUT_LINE (indx | | ‘ ’ | | 1_list (indx)); END LOOP;
FOR indx IN -1 .. 1_list.LIMIT LOOP DBMS_OUTPUT.PUT_LINE (indx | | ‘ ’ | | 1_list (indx) ); END LOOP;
FOR indx IN 1_list.FIRST . . 1_list.LAST LOOP DBMS_OUTPUT.PUT_LINE (indx | | ‘ ’ | | 1_list (indx)); END LOOP;

Go to Question:

Prev Question

Next Question