Answer / senthil kumar

6. full outer join : ALL UNMATCHED DATA FROM BOTH TABLES

SELECT * FROM TABLE A FULL OUTER JOIN TABLE B ON (A.ID= B.ID)
Ex:

TABLE A
NO NAME 1 X
2 Y
5 Z

TABLE B
NO NAME 1 XX
2 YY
3 ZZ
4 AA

OUTPUT:
NO NAME NO NAME
1 X 1 XX
2 Y 2 YY
3 ZZ
4 AA
5 Z

Is nosql faster than sql?

0 Answers  

---

what is union, minus and interact commands? : Sql dba

0 Answers  

---

Is sql procedural language?

0 Answers  

---

what is the purpose of update command in oracle?

7 Answers   MBT,

---

What are the types of SQL Statement?

3 Answers  

---

How is Oracle 10g helpful when compared to oracle 9i and what is grid computing

1 Answers   Flextronics,

---

What is t-sql? : Transact sql

0 Answers  

---

how to install mysql? : Sql dba

0 Answers  

---

What is sql data?

0 Answers  

---

how can we write a column values horizontal by using sql stmt; ex: select name from table_name;(actual output) a b c d require output is a b c d

5 Answers   Honeywell, Interact,

---

What are the topics in pl sql?

0 Answers  

---

Enlist the characteristics of pl/sql?

0 Answers  

---