Plsql Collection Methods

Collection Methods

A collection method is a built-in PL/SQL subprogram that returns information about a collection or operates on a collection. Collection methods make collections easier to use, and make your applications easier to maintain. You invoke a collection method using dot notation. For detailed syntax, see Call. You cannot invoke a collection method from a SQL statement.

Types of Methods

1. Checking If a Collection Element Exists (EXISTS Method)
2. Counting the Elements in a Collection (COUNT Method)
3. Checking the Maximum Size of a Collection (LIMIT Method)
4. Finding the First or Last Collection Element (FIRST and LAST Methods)
5. Looping Through Collection Elements (PRIOR and NEXT Methods)
6. Increasing the Size of a Collection (EXTEND Method)
7. Decreasing the Size of a Collection (TRIM Method)
8. Deleting Collection Elements (DELETE Method)