How is a varray of varrays declared, and how are its elements referenced?
What will be an ideal response?
In Oracle9i, it is possible to create collection of a collection (multiple level collection)
like varray of varrays. For example,
DECLARE
TYPE V_TYPE1 IS VARRAY(2) OF NUMBER;
TYPE V_TYPE2 IS VARRAY(4) OF V_TYPE1;
V1 V_TYPE1 := V_TYPE1(10, 20);
V2 V_TYPE2 := V_TYPE2(V1);
V1 is a varray and V2 is a varray of varray V1. Varray V1 contains 2 elements, and
varray V2 contains 2*4=8 elements. Elements of varray V1 are referenced with one subscript, but elements of varray V2 are referenced with two subscripts. For example,
V1(1), V2(1)(2).
You might also like to view...
In a struct, all members are ____________ by default
a. public b. private c. global d. all of the above
Smart Guides are dashed lines that display on your slide when you are moving an object to assist you with alignment
Indicate whether the statement is true or false
Since its launch in ________, Twitter has become the number-two social media site and one of the top ten websites on the Internet
Fill in the blank(s) with correct word
Explain the following three types of pointers: physical address pointer, relative address pointer, and logical key pointer.
What will be an ideal response?