PRIOR(n) collection method returns index number that precedes index n in collection - PL/SQL Packages

Q.  Which collection method Returns the index number that precedes index n in a collection?
- Published on 07 Jul 15

a. PRIOR(n)
b. LAST
c. LIMIT
d. COUNT

ANSWER: PRIOR(n)
 
The PRIOR(n) return the index number that precedes index n in PL/SQL table. If the value n has no predecessor then it returns null. the PRIOR and NEXT do not wrap from one end to the other.

Post your comment / Share knowledge


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