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

Can we insert in sql function?

1094

---

What are the operators in sql?

1034

---

How does postgresql compare to mysql?

1039

---

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

1029

---

What are the sql aggregate functions?

1138

---

When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?

1121

---

What is auto increment?

1008

---

What is forward declaration in pl sql?

1086

---

How does index help in query performance?

1032

---

What are tables and fields in the database?

1115

---

Explain autonomous transaction.

1162

---

what is csv? : Sql dba

1001

---

Explain spool.

1186

---

How do you respond to dementia behavior?

974

---

What is data type in sql?

970

---