Quick Search:
 The Oracle UNION Operator      [Return To Index] Jump to:  


The UNION operator is used to combine the result-set of two or more SELECT statements.

UNION Requirements:

  • Each SELECT statement within the UNION must have the exact same number of columns
  • The columns must also have similar data types.
  • The columns in each SELECT statement must be in the exact same order.

Example Syntax:

SELECT column_name(s) FROM table1
SELECT column_name(s) FROM table2;

Related Links:
   Home |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us © 2003 - 2024 psoug.org