Main diff between varray and nested tablea

3 Answers   Polaris, TCS,

---

what is ref cursor in pl/sql?

3 Answers  

---

What is the best strategy to use COMMIT in a pl/sql loop?

3 Answers  

---

What is an index? What are the types of indexes? How many clustered indexes can be created on a table?

0 Answers  

---

I have a small PL/SQL Block assume in this way begin select * from emp where empno=100; exception when others then <Some Messages> when no_data_found then <Some Messages> when too_many_rows then <Some Messages> end; The question which he asked was whether this block will get executed normally or it will throw error ? If errored out then what is the reason for the error ? Could anybody please help me ? Regards Nakul Venkataraman

3 Answers   Satyam,

---

Why do we use sqlite?

0 Answers  

---

What is nosql db?

0 Answers  

---

What is a natural join sql?

0 Answers  

---

What is sql table?

0 Answers  

---

Can a key be both primary and foreign?

0 Answers  

---

How to get each name only once from an employee table?

0 Answers  

---

Q1.all the depts which has more then 10 empls? Q2.all the dept which does not have any emply? Q3 all the emp which does not have any dept? Q4 get all the emply detais with the dept details it dept is exit otherwise any emp details? Q5 how to debugg the dynamic sql and packages?

2 Answers  

---