PL/SQL - Collections

PL/SQL telah menyediakan teknik pengumpulan data sbb:

No	Method Name & Purpose
1	EXISTS(n) Returns TRUE if the nth element in a collection exists; otherwise returns FALSE. SELECT * FROM data_karyawan WHERE EXISTS (SELECT * FROM jabatan_karyawan  WHERE jab_id = jab_kar);
2	COUNT Returns the number of elements that a collection currently contains. select count(*) from data_karyawan;
3	LIMIT Checks the maximum size of a collection. SELECT *  FROM   data_karyawan ORDER BY nama OFFSET 20 ROWS FETCH NEXT 10 ROWS ONLY; -->ini hanya db 12 ke atas, kalau untuk versi 12 kebawah gunakan sub query.
4	FIRST Returns the first (smallest) index numbers in a collection that uses the integer subscripts.
5	LAST Returns the last (largest) index numbers in a collection that uses the integer subscripts.
6	PRIOR(n) Returns the index number that precedes index n in a collection.
7	NEXT(n) Returns the index number that succeeds index n.
8	EXTEND Appends one null element to a collection.
9	EXTEND(n) Appends n null elements to a collection.
10	EXTEND(n,i) Appends n copies of the ith element to a collection.
11	TRIM Removes one element from the end of a collection.
12	TRIM(n) Removes n elements from the end of a collection.
13	DELETE Removes all elements from a collection, setting COUNT to 0.
14	DELETE(n) Removes the nth element from an associative array with a numeric key or a nested table. If the associative array has a string key, the element corresponding to the key value is deleted. If n is null, DELETE(n) does nothing.
15	DELETE(m,n) Removes all elements in the range m..n from an associative array or nested table. If m is larger than n or if m or n is null, DELETE(m,n) does nothing.