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,

---

What is the difference between alter trigger and drop trigger statements?

0 Answers  

---

Why truncate is faster than delete?

0 Answers  

---

Is sql injection illegal?

0 Answers  

---

What is the usage of NVL?

7 Answers   Infosys, Micro Infotek,

---

how will i became good database developer?

1 Answers  

---

need to split a string into separate values. eg. col1 col2 ---------- 100 - 'a,b,c' 200 - 'a,x,d,e' 300 - 'c' result: value count ------------- a - 2 b - 1 c - 2 etc.

2 Answers  

---

I have 2 Databases. How can create a table in particular database? How can i know the list of tables presented each database?( in oracle 10g)

5 Answers   Relq,

---

How do I order columns in sql?

0 Answers  

---

What is AUTH_ID and AUTH_USER in pl/sql ?

0 Answers   INDUS,

---

Delete the emps whose salaries are lowest sals of their own dept.

5 Answers  

---

what is table? : Sql dba

0 Answers  

---