Oracle PL/SQL Programming: A Developer's Workbook

Intermediate

8-10.	How can you create and use default constructors for variable arrays?
8-11.	What is the result of running this block? DECLARE TYPE v_single_element_type IS VARRAY(1) OF VARCHAR2(1); v_single_element_array v_single_element_type; BEGIN v_single_element_array := v_single_element_type(1,2); END;
8-12.	Identify the variable array methods that have the following characteristics: Returns TRUE if an element has been defined or FALSE if it has not. Returns the number of elements a virtual array contains. It is 0 when the array is initially defined. Returns the upper bound specified for the virtual array. Returns the number of the first element in the variable array. It returns NULL if no elements are defined. Because variable arrays are never sparse and their order is tightly maintained, this function never returns anything other than NULL or 1. Returns the number of the last element in the variable array. It returns NULL if no elements are defined. Returns the number of the next lowest element to the one specified. If there are no lower elements, it returns NULL. It also returns NULL if no elements are defined. Because variable arrays are never sparse and their order is maintained, the value returned is always sequential. Returns the number of the next highest element to the one specified. If there are no higher elements, it returns NULL. It also returns NULL if no elements are defined. Because variable arrays are never sparse and their order is maintained, the value returned is always ...