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 are the 3 types of behavioral triggers?

0 Answers  

---

what will be the output: select 1 from emp union all select 2 from emp;

2 Answers   iNautix,

---

What is difference between pls_integer and integer?

0 Answers  

---

What is transaction control language (tcl)?

0 Answers  

---

What is the need of merge statement?

0 Answers  

---

Initially question was asked to mention the types of indexes. Then asked about BITMAP INDEX and B-Tree Index

2 Answers   Polaris,

---

What are the default Oracle triggers??

3 Answers   CGI, Tech Mahindra,

---

What is dense_rank in sql?

0 Answers  

---

how to get @@error and @@rowcount at the same time? : Sql dba

0 Answers  

---

How packaged procedures and functions are called from the following?

2 Answers  

---

Types of optimization?

6 Answers   Microsoft,

---

Can we create table in function?

0 Answers  

---