Question

What are the four set operations supported in Oracle?

Answer 1

The four set operations supported in Oracle are union, intersection, difference, and Cartesian product.

Step-by-step explanation:

The four set operations supported in Oracle are:

1. Union: The union of two sets includes all the elements from both sets without duplication. For example, if set A = {1, 2, 3} and set B = {3, 4, 5}, then A union B = {1, 2, 3, 4, 5}.
2. Intersection: The intersection of two sets includes only the elements that are common to both sets. For example, if set A = {1, 2, 3} and set B = {3, 4, 5}, then A intersection B = {3}.
3. Difference: The difference between two sets includes the elements that are in one set but not in the other. For example, if set A = {1, 2, 3} and set B = {3, 4, 5}, then A minus B = {1, 2}.
4. Cartesian Product: The Cartesian product of two sets includes all possible ordered pairs where the first element is from the first set and the second element is from the second set. For example, if set A = {1, 2} and set B = {3, 4}, then A x B = {(1, 3), (1, 4), (2, 3), (2, 4)}.