How will you debug your procedure? If your procedure is around 2000 lines and the expected output is 10 and we get only output 5.So how will you debug it? Somebody pls give the correct answer?

2 Answers   Fidelity,

---

I want to create synonym for table emp but in my pc it is giving insufficient previliges.I am using user scott.Please suggest me.

3 Answers  

---

what are the advantages of using stored procedures? : Sql dba

0 Answers  

---

Is full outer join same as cross join?

0 Answers  

---

How is a process of pl/sql compiled?

0 Answers  

---

Why do we create stored procedures & functions in pl/sql and how are they different?

0 Answers  

---

Can any one tell me how to increase the performance of a sql query ie what are the performance tips in creating or writing a sql query !!?

3 Answers   eBay,

---

write a query to find out the no. of employees whose age is less than 25 and max of salary for the employees belonging to a particular department is less than 20000

6 Answers  

---

what is difference between procedure and function

10 Answers   MCN Solutions, Wipro,

---

wt is the diff b/w greast and max ,least and min? wt is the diff b/w case and decod?

4 Answers   Oracle, TCS, Tecnics,

---

Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql

0 Answers  

---

explain the difference between delete , truncate and drop commands? : Sql dba

0 Answers  

---