O'Reilly logo

Oracle PL/SQL Programming: A Developer's Workbook by Andrew Odewahn, Steven Feuerstein

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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:

  1. Returns TRUE if an element has been defined or FALSE if it has not.

  2. Returns the number of elements a virtual array contains. It is 0 when the array is initially defined.

  3. Returns the upper bound specified for the virtual array.

  4. 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.

  5. Returns the number of the last element in the variable array. It returns NULL if no elements are defined.

  6. 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.

  7. 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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required