MINUS returns a record that appears in the first query and the record in the second query; INTERSECT returns a record in the two queries; Union returns the records of two queries
E.G: INSERT INTO TABLE3 (select * from table1 minus select * from table2) The function of the SQL statement on the top of the table is to insert the data present in Table1 but not in Table2 in the Table 3.