Answer Posted / 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

How to connect a sql*plus session to an oracle server?

1118

---

Define commit?

992

---

How do I run a pl sql program?

1121

---

What is difference between left and right outer join?

981

---

What is difference between ms sql and mysql?

956

---

What are the different set operators available in sql?

1017

---

Can we write dml inside a function in sql server?

939

---

What is a subquery in sql?

1033

---

What is set serveroutput on?

1126

---

How do I truncate a word?

1079

---

Is there any restriction on the use of union in embedded sql?

1152

---

What are the two types of periodical indexes?

936

---

what is error ora-03113: end-of-file on communication channel?

1153

---

What is microsoft t sql?

936

---

What is cte sql?

981

---