SET OPERATIONS IN ORACLE 9i

Is it possi开发者_StackOverflow中文版ble 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

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.