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 t sql used for?

0 Answers  

---

How to display Row Number with Records in Oracle SQL Plus?

0 Answers   MCN Solutions,

---

table name :Tab fields name 1.trx_no (pk) 2.trx_date 3.account code (7 char) 4.account type (1 char) 5.amt Tab contains account code day wise debit and credit transaction , account type fiels can have 2 value D for debit and c for Credit . write a query to display the account code wise total debit and credit bal for the month of april 2004. write a query to display account code wise new amt credit for the april 2004

2 Answers   Maruti Suzuki,

---

What are analytic functions in sql?

0 Answers  

---

What is indexes?

0 Answers  

---

how do you know if your mysql server is alive? : Sql dba

0 Answers  

---

How to use sql*plus built-in timers?

0 Answers  

---

How can I see all tables in sql?

0 Answers  

---

how can i create a user defined datatype

3 Answers  

---

select sal from emp group by sal

3 Answers   TCS,

---

How can I tell if sql is running?

0 Answers  

---