Name some of the inbuilt method of Nested Table of Oracle

 Posted by Niladri.Biswas on 5/2/2013 | Category: Oracle Interview questions | Views: 1456 | Points: 40
Answer:

a)First : Returns the subscript of the first element in the nested table

b)Last : Returns the subscript of the last element in the nested table.

c)Prior : Returns the subscript of the previous element in the nested table.

d)Next : Returns the subscript of the next element in the nested table.

e)Exists : Returns true if the element at te specified position is found else false

f)Trim : Removes the last N elements from the collection


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response