SET OPERATIONS IN ORACLE 9i

Question

Is it possible to do SET OPERATIONS using more than one column in the SELECT clause?

For example:

SELECT NAME, AGE FROM tableA
MINUS
SELECT NAME, AGE from tableB

Answer 1

Yes - see the MINUS example.

They operate on the column(s) in the SELECT clause, and require the data types, not the column names, to match in order to work.