Answer / sunita

select * from tab
where rownum=2;

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 fastest way of accessing a row in a table?

5 Answers   TCS,

---

What are % TYPE and % ROWTYPE ? What are the advantages of using these over datatypes?

4 Answers  

---

How to install oracle sql developer?

0 Answers  

---

What is view explain with example?

0 Answers  

---

Types of cursor locks and explanation each of them ?

3 Answers   DELL, HP Finsoft,

---

Does a primary key have to be a number?

0 Answers  

---

How do you display "13th of November, 17 days left for month end" without hardcoding the date.

3 Answers  

---

what is bcp? When is it used?

0 Answers  

---

What is the difference between stored procedure and view?

0 Answers  

---

Is keyword pl sql?

0 Answers  

---

How is Oracle 10g helpful when compared to oracle 9i and what is grid computing

1 Answers   Flextronics,

---