Differences between union, unionall, minus, and intersect in Oracle

Union: returns the union of two result sets. Only one repeated part of the two result sets is retained. Unionall: Union of two result sets to retain the duplicate parts of the two result sets. Minus: The result set that appears in the first result set but does not appear in the second result set. Intersect: intersection, the duplicate part of the two result sets. Example

Union: returns the union of two result sets. Only one repeated part of the two result sets is retained. Union all: union of two result sets to retain the duplicate parts of the two result sets. Minus: The result set that appears in the first result set but does not appear in the second result set. Intersect: intersection, the duplicate part of the two result sets. Example

Union: returns the union of two result sets. Only one repeated part of the two result sets is retained.

Union all: union of two result sets to retain the duplicate parts of the two result sets.

Minus: The result set that appears in the first result set but does not appear in the second result set.

Intersect: intersection, the duplicate part of the two result sets.

Example:

A (1, 2, 3, 4, 5, 6)

B (1, 2, 5, 6, 7)

A union B (1, 2, 3, 4, 5, 6, 7)

A union all B (, 7)

A minus B (3, 4)

A intersect B (1, 2, 5, 6)