Skip to Main Content
Oracle PL/SQL Programming: A Developer's Workbook
book

Oracle PL/SQL Programming: A Developer's Workbook

by Steven Feuerstein, Andrew Odewahn
May 2000
Intermediate to advanced content levelIntermediate to advanced
594 pages
11h 32m
English
O'Reilly Media, Inc.
Content preview from 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:

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

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle Database 12c PL/SQL Programming

Oracle Database 12c PL/SQL Programming

Michael McLaughlin
Oracle PL/SQL for DBAs

Oracle PL/SQL for DBAs

Arup Nanda, Steven Feuerstein
Oracle PL/SQL For Dummies

Oracle PL/SQL For Dummies

Michael Rosenblum, Paul Dorsey

Publisher Resources

ISBN: 9781449324070Supplemental ContentErrata Page