Answer Posted / vinod singh kushwah

UNION
The UNION command is used to select related information
from two tables, much like the JOIN command. However, when
using the UNION command all selected columns need to be of
the same data type.

Note: With UNION, only distinct values are selected.

SQL Statement 1
UNION
SQL Statement 2

Employees_Norway:

E_ID E_Name
01 Hansen, Ola
02 Svendson, Tove
03 Svendson, Stephen
04 Pettersen, Kari

Employees_USA:

E_ID E_Name
01 Turner, Sally
02 Kent, Clark
03 Svendson, Stephen
04 Scott, Stephen


------------------------------------------------------------
--------------------

Using the UNION Command
Example
List all different employee names in Norway and USA:

SELECT E_Name FROM Employees_Norway
UNION
SELECT E_Name FROM Employees_USA

Result

E_Name
Hansen, Ola
Svendson, Tove
Svendson, Stephen
Pettersen, Kari
Turner, Sally
Kent, Clark
Scott, Stephen

Note: This command cannot be used to list all employees in
Norway and USA. In the example above we have two employees
with equal names, and only one of them is listed. The UNION
command only selects distinct values.


UNION ALL
The UNION ALL command is equal to the UNION command, except
that UNION ALL selects all values.

SQL Statement 1
UNION ALL
SQL Statement 2


------------------------------------------------------------
--------------------

Using the UNION ALL Command
Example
List all employees in Norway and USA:

SELECT E_Name FROM Employees_Norway
UNION ALL
SELECT E_Name FROM Employees_USA

Result

E_Name
Hansen, Ola
Svendson, Tove
Svendson, Stephen
Pettersen, Kari
Turner, Sally
Kent, Clark
Svendson, Stephen
Scott, Stephen

Explain an extent?

1150

---

how to do daily transactions with out sql* loader control file regesterd in apps?

1726

---

If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...

2285

---

What is SQL Tuning Advisor in Oracle?

1245

---

what are bitmap indexes? How does they work?

2302

---

What is the difference between truncate & delete command?

1231

---

Explain the function of optimizer in oracle?

1195

---

How to assign values to data fields in record variables?

1074

---

How to use fetch statement in a loop?

1066

---

Explain the importance of .pll extension in oracle?

1057

---

What is an oracle wallet?

988

---

How to connect ms access to oracle servers?

1056

---

Explain the use of file option in exp command.

1171

---

What are the original export and import utilities?

1253

---

What is set verify off in oracle?

1153

---