Which of the following statements are not correct about EXTEND Method?

Options
- EXTEND can use with index-by tables
- EXTEND cannot use to add elements to an uninitialized.
- EXTEND appends one null element to a collection.
- None of the Above

CORRECT ANSWER : EXTEND can use with index-by tables

Discussion Board
EXTEND Method

To increase the size of a nested table or varray, use EXTEND. This procedure has three forms:
1. EXTEND appends one null element to a collection.
2. EXTEND(n) appends n null elements to a collection.
3. EXTEND(n,i) appends n copies of the ith element to a collection.
You cannot use EXTEND with index-by tables. You cannot use EXTEND to add elements to an uninitialized collection. If you impose the NOT NULL constraint on a TABLE or VARRAY type, you cannot apply the first two forms of EXTEND to collections of that type.

Prajakta Pandit 02-21-2017 12:10 AM

Write your comments


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Related Content

Advertisement
 
▲