MULTISET « PL SQL « Oracle PL / SQL






1.MULTISET EXCEPT operator finds the elements remaining from the first set after removing any matching elements from the second set
2.MULTISET EXCEPT table collection
3.MULTISET INTERSECT operator finds the intersection or matching values between two sets
4.MULTISET INTERSECT table collection
5.MULTISET UNION DISTINCT table collection
6.MULTISET UNION operator performs a UNION ALL operation on two collections
7.MULTISET UNION table collection