Using Collection Methods Assignment Help

Assignment Help: >> Cursors - Using Collection Methods

Using Collection Methods:

There are many methods which can be used along with the table type. Subsequent are the list of collection methods:

  • COUNT
  • EXISTS
  • FIRST
  • LAST
  • PRIOR
  • NEXT
  • DELETE

 

Using COUNT

Count returns the number of elements in which the collection holds. For instance, if there are 10 elements the count will show 10.

Using FIRST and LAST

As the names denotes, FIRST and LAST are used to return the first and the last index number in the collection.

PRIOR and NEXT

PRIOR(n) denotes the number which precedes the index n in the collection. The NEXT keyword is used to traverse to the next element.

Using DELETE

DELETE is used to delete the specified part from the collection. It is important to Note that this does not delete data from the table. It Delete without parameter deletes all the elements and delete with a number deletes the specified element alone.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd