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

What is the full form of sql?

0 Answers  

---

Does a join table need a primary key?

0 Answers  

---

Can a view be mutating? If yes, then how?

0 Answers  

---

1.when will you use week refcursor and when will you use strong ref cursor ? 2.what is the use of sql trace..how do you use it ? 3.can you please send all the sql plus commands...like set line 6000....

1 Answers   Satyam,

---

what is the functionality of the function htmlentities? : Sql dba

0 Answers  

---

---

What is sp_helptext?

0 Answers  

---

Which version of sql do I have?

0 Answers  

---

Is delete faster than truncate?

0 Answers  

---

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

0 Answers  

---

what is the difference between myisam static and myisam dynamic? : Sql dba

0 Answers  

---

take one table is t1 and in that column name is f1 f1 column values are 200 5000 3000 7000 300 600 100 400 800 400 i want display the values asc and desc in a single output. sample output is f1.a 100 200 300 400 500 600 etc...... and f1.d is 5000 4000 3000 2000 1000 etc...

9 Answers   Zensar,

---

What are inner and outer joins examples of both?

0 Answers  

---