This video gives examples of three set operators: UNION, INTERSECT, MINUS. The union compatible rule is also explained. Set operators are used when output comes from more than one SQL statement. (15 of 15) There is also an "Advanced SQL" series. (Search for "databasemec" for tutorials using SQL Server.)
Watch video 15 of 15 SQL Basics with Oracle - Traditional set operators: UNION, INTERSECT & MINUS online without registration, duration hours minute second in high quality. This video was added by user J Kreie Database 11 July 2012, don't forget to share it with your friends and acquaintances, it has been viewed on our site 14,492 once and liked it 55 people.