Chapter 18 Collections

1)Create the following script. Create an index-by table and populate it with the instructor’s full name. In other words, each row of the index-by table should contain first name, middle initial, and last name. Display this information on the screen.
A1: Answer: Your script should look similar to the following: 
SET SERVEROUTPUT ON 
DECLARE 
   CURSOR name_cur IS 
      SELECT first_name||' '||last_name name 
        FROM instructor; 

   TYPE name_type IS TABLE OF VARCHAR2(50) 
      INDEX BY BINARY_INTEGER; 
   name_tab name_type; 

   v_counter INTEGER := 0; 
BEGIN 
   FOR name_rec IN name_cur LOOP 
      v_counter := v_counter + 1; 
      name_tab(v_counter) := name_rec.name; 

      DBMS_OUTPUT.PUT_LINE ('name('||v_counter||'): '|| 
         name_tab(v_counter)); 
   END LOOP; 
END;

In the preceding ...

Get Oracle® PL/SQL® Interactive Workbook, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial