what is cursor procedure

1 Answers   iGate,

---

What are the types of keys?

0 Answers  

---

What does data normalization mean?

0 Answers  

---

Why are sql stored procedures used?

0 Answers  

---

how to write utl file pkg in SQL

1 Answers   Oracle,

---

---

Explain how exception handling is done in advance pl/sql?

0 Answers  

---

What is meant by user defined function?

0 Answers  

---

I have a Employee table with columns ename,eid,salary,deptno. How to retrieve sum of salary for each deptno?

8 Answers   L&T,

---

How can I pass the inner procedure value to outer procedure ?

2 Answers  

---

What is primary key and foreign key?

0 Answers  

---

Explain commit, rollback and savepoint.

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,

---