Difference Between Oracle Join and Union

_____________________________________________________________________________________________________________________

The Eucharistic Miracles of the World

Join:

·        Joins are used to join two or more tables to extract the data

·        Joins are used to retrieve the relational based data from the tables

·        Joins mainly used to filter the records from the multiple tables

·        Joins can be used to retrieve the matching and non-matching data

·        There are different types of joins available in the RDBMS like equi, non-equi, cartitian/cross join, left outer,  right outer.

·        Joins are used to join the table columns with specific values or other table columns.

·        Join allows duplicates

 

Union

·        Union is a set function

·        Union is used to combine 2 or more select query result set outputs

·        Union removes the duplicate rows from the result set

·        Number and names of columns should match in all the select queries

·        Union operator cannot be used in create view statement.

_____________________________________________________________________________________________________________________

Website Stats

0 comments:

Post a Comment

Labels

Oracle (580) General (60) Unix (47) Script (41) Blog (23) OCI (3) SQL* Loader (3) Datapump (2) Software (1)
DBA Tips
 

acehints.com Copyright 2011-21 All Rights Reserved | Site Map | Contact | Disclaimer