Main diff between varray and nested tablea

3 Answers   Polaris, TCS,

---

What is meant by Materialized view?

2 Answers   iGate, Marlabs, Polaris,

---

wa procedure to return the month and the no'f developers joined in each month.

4 Answers   Fidelity,

---

Why do we use %rowtype & %type in plsql?

0 Answers  

---

what is Hash join?how it is different from inner join?what is the sign used for inner join?(eg: like the (+) sign used for outer join)?

3 Answers   TCS,

---

---

Can a composite key be null?

0 Answers  

---

What are the advantages of VIEW?

5 Answers  

---

Can a key be both primary and foreign?

0 Answers  

---

How to access the current value and next value from a sequence?

6 Answers  

---

Can we commit inside a trigger?

0 Answers  

---

What are the constraints available in sql?

0 Answers  

---

What is magic table?

6 Answers  

---