Explain the usage of WHERE CURRENT OF clause in cursors ?

3 Answers  

---

What are the two types of exceptions.

0 Answers  

---

How do I start pl sql?

0 Answers  

---

How many triggers can be implemented for a table?

3 Answers   HSBC,

---

What is 19 null in sql?

0 Answers  

---

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

2 Answers   iNautix,

---

what is view? : Sql dba

0 Answers  

---

source destination distance chennai bangalore 500 bangalore chennai 500 hyd delhi 1000 delhi hyd 1000 bangalore hyd 800 Here chennai to bangalore and bangalore to chennai is same distance. and hyd and delhi also same criteria. Based on the distance i want to display only one row using sql query?

4 Answers   JPMorgan Chase,

---

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?

4 Answers   KPIT,

---

How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000

0 Answers   BT,

---

How to handle bulk data?

0 Answers  

---

write a query that returns first characters of each word in Oracel/Sql pl sql

5 Answers  

---