Difference Between Oracle Join and Union

advertisements

_____________________________________________________________________________________________________________________

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.

_____________________________________________________________________________________________________________________

A visitor from Denver viewed 'Troubleshoot & fix ORA-01002: fetch out of sequenc' 30 mins ago
A visitor from Vladimir viewed 'Oracle NO_INDEX hint: Syntax, Purpose and Example' 47 mins ago
A visitor from Klagenfurt viewed 'How to Increase, Decrease or Resize FRA(Flash Reco' 1 hr 17 mins ago
A visitor from Alabama viewed 'How to Find out / Check SGA and PGA size of Oracle' 2 hrs 15 mins ago
A visitor from Navi mumbai viewed 'DGMGRL Error: ORA-16820: fast-start failover obser' 3 hrs 21 mins ago

0 comments:

Post a Comment

Labels

Oracle (629) Script (86) General (77) Unix (47) Blog (23) Technology (19) gadget (6) games (6) Business (3) OCI (3) SQL* Loader (3) Datapump (2)
 

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