O'Reilly logo

Oracle SQL and PL/SQL Handbook: A Guide for Data Administrators, Developers, and Business Analysts by John Adolph Palinski

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

Set Operator Rules

Set operators are used to combine the records from multiple SELECT statements. The set operator is placed between the two SELECT statements. The operator tells Oracle how the records that each of the SELECT statements retrieves must be merged, compared, or discarded until one virtual table is created. The entire virtual record from each record set is evaluated against each other; therefore, the following rules apply:

  1. Each of the SELECT clauses must have the same number of expressions.

  2. Each expression in the SELECT clause must have the same data type as the corresponding expression in the other SELECT clauses.

  3. Each SELECT statement is part of one overall statement. The minor SELECT statements may have all of the SELECT clauses ...

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