SET Operations
In SQL the order of commands are:
Usually ORDER BY is the last command in SQL. But 11g has introduced …
MINUS returns all the distinct rows from first select statement which are not present in second select statement.
Below is the graphical representation of MINUS operator.
CREATE TABLE EMPLOYEES_MINUS_30 AS SELECT EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, HIRE_DATE,…
INTERSECT operators returns the distinct common rows from each query.
Below is the graphical representation of INTERSECT operator.
CREATE TABLE EMPLOYEES_INTERSECT_30 AS SELECT EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, HIRE_DATE, JOB_ID, SALARY,…
Oracle SET operators combine two or more queries and return single set of result.
UNION operators combine two or more queries and return the …