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

What information is needed to connect sql*plus an oracle server?

1004

---

What action do you have to perform before retrieving data from the next result set of a stored procedure ?

2555

---

What is cross join sql?

902

---

Do foreign keys improve performance?

1005

---

What is java sql connection?

1030

---

Is hadoop a nosql?

982

---

What is pl sql block in dbms?

990

---

Is sql better than access?

994

---

What are the methods of filing?

918

---

What is a sql driver?

984

---

How do you update a sql procedure?

1011

---

What is the limitation on the block size of pl/sql?

972

---

What is java sql package?

1072

---

Why we use stored procedure instead of query?

981

---

What is meaning of <> in sql?

1055

---