O'Reilly logo

OCA Oracle Database 11g: SQL Fundamentals I: A Real-World Certification Guide by Steve Ries

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Using set operators within SQL

Our last method of combining queries is through the use of set operators. While set operators are generally not used by SQL programmers on a day-to-day basis, when the situation calls for them, they can be extremely useful. Before we examine SQL set operators in detail, it is advantageous for us to briefly review mathematical set theory to see how they work.

Principles of set theory

If you think back to your school math classes, you may remember learning about a topic known as set theory. Set theory is the branch of mathematics that involves the study of collections of objects, or sets. Because databases deal with collections of data, set theory is relevant to the more theoretical aspects of relational database theory. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required