Diksha IT Training Centre

                Set Operator uses and Benefits in Oracle Database   Today we will discuss about different Set operators used in SQL with examples. SET operator used to select data from multiple tables as Set operators combine the results of two component queries into a single result. Queries containing set operators are called compound queries. Through SET Operator in SQL we don’t need to use Joins and make alias of table to get the common record and all distinct row selected by query. SQL Set Operators are of 4 parts which work similar to Mathematics which we learn in class 10 th  or so. 1.     UNION 2.     UNION ALL 3.     INTERSECT 4.     MINUS/EXCEPT.     Things to Remember while using SET operator: Select clause should have the same number of columns and columns must be of same data type, Column needs to be specified in the same order in the select clause.   UNION: UNION set operator use to select all distinct rows selected by either query. UNION returns al