Answer / shwetha k

A cursor is a pointer to pointing to this memory area and used to retrieve data row by row instead of all row at a time.
select statement fetches only one row.so to overcome this problem cursor is used to hold the set of rows or data in one variable and can do whatever manipulation we want to do.

What is the difference between left outer join and left join?

0 Answers  

---

Does pl sql work in mysql?

0 Answers  

---

What is the purpose of normalization?

0 Answers  

---

what are the difference between clustered and a non-clustered index? : Sql dba

0 Answers  

---

Give the order of sql select?

0 Answers  

---

What is difference between a Cursor declared in a procedure and Cursor declared in a package specification ?

2 Answers   JDA,

---

What is crud diagram?

0 Answers  

---

how to find the second highest salary from emp table?

211 Answers   CIS, Cognizant, Cosmosoft, DAS, EDS, GreenTech, HOV Services, IBM, Infosys, National Institute of Science and Technology, Patni, Persistent, Polaris, TCS, Wipro, Yardi, Zensar,

---

Write a sql query to get the third highest salary of an employee from employee_table?

0 Answers  

---

How to connect a sql*plus session to an oracle server?

0 Answers  

---

difference between cursor and procedure in a package

3 Answers   PCS,

---

How run sql*plus commands that are stored in a local file?

0 Answers  

---