Oracle PL/SQL Programming: A Developer's Workbook

Intermediate

6-14.

Consider the following table declarations: -- table of numbers TYPE number_table_type IS TABLE OF number INDEX BY BINARY_INTEGER; number_table number_table_type; -- table of empnos TYPE empno_table_type IS TABLE OF employee.employee_id%TYPE INDEX BY BINARY_INTEGER; empno_table empno_table_type; -- table of employee table rows TYPE employee_table_type IS TABLE of employee%ROWTYPE INDEX BY BINARY_INTEGER; employee_table employee_table_type; -- table of records of employee numbers TYPE employee_record IS RECORD (empno employee.employee_id%TYPE ); TYPE employee_record_table_type IS TABLE OF employee_record INDEX BY BINARY_INTEGER; employee_record_table employee_record_table_type; Complete the following chart by supplying the command that assigns the value “100” to element number 100. For the tables of records, assign the value to the empno field. Table Name Syntax Number_table   Empno_table   Employee_table   Employee_record_table

6-15.

Oracle offers a set of “methods” (different in syntax usage from functions) to help you work with collections. Identify the method associated with each description: Returns TRUE if an element has been defined or FALSE if it has not. Returns the number of elements in an index-by table. It is 0 when the table is initially defined. Returns the number of the first element in the index-by table. It returns NULL if no elements are defined. Returns the number of the last element in the index-by table. It returns NULL if no elements are defined. Returns the ...