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.
| ||||||||||
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:
|
Get Oracle PL/SQL Programming: A Developer's Workbook 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.