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

why we go for package? what are the advantages of using instead of seperate procuderes or functions

3 Answers   IBM, TCS,

---

What is synonyms?

0 Answers  

---

What found sql?

0 Answers  

---

How do I run a program in pl sql?

0 Answers  

---

How to change the order of columns in Oracle SQL Plus ?

0 Answers   MCN Solutions,

---

---

Suppose I have to create a view on a table, that is not yet been created by DBA. I khow the table structure. Is it possible to create the view before DBA creates this table? If yes then how? Is it possible to create synonym in this way?

4 Answers   IBM, Metric Stream,

---

Can sql function call stored procedure?

0 Answers  

---

What are pl sql procedures?

0 Answers  

---

Is oracle and sql same?

0 Answers  

---

What is the relation b/w view and trigger

3 Answers   Accenture, TCS,

---

Does it possible to pass object (or) table as an argument to a remote procedure?

1 Answers   TCS,

---

What is data abstraction in sql?

0 Answers  

---