What is the significance of MULTISET EXCEPT operator?

Options
- It evaluate two sets and returns one set
- It removes duplicates from a collection.
- It removes one set from another
- All of the above


CORRECT ANSWER : It removes one set from another

Discussion Board
MULTISET EXCEPT

MULTISET EXCEPT returns the elements of the first set that are not present in the second set. MULTISET EXCEPT takes as arguments two nested tables and returns a nested table whose elements are in the first nested table but not in the second nested table. The two input nested tables must be of the same type, and the returned nested table is of the same type as well.

The ALL keyword instructs Oracle to return all elements in nested_table1 that are not in nested_table2. For example, if a particular element occurs m times in nested_table1 and n times in nested_table2, then the result will have (m-n) occurrences of the element if m >n and 0 occurrences if m<=n. ALL is the default.

The DISTINCT keyword instructs Oracle to eliminate any element in nested_table1 which is also in nested_table2, regardless of the number of occurrences.

The element types of the nested tables must be comparable.

Prajakta Pandit 02-22-2017 12:34 AM

Write your comments

 
   
 
 

Enter the code shown above:
 
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Advertisement