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.

A table has 150 records. How do you retrieve 100th row to 120th row from that table ?

21 Answers   IBM,

---

What is compiled query?

0 Answers  

---

what is the use of set statement in tsql? : Transact sql

0 Answers  

---

Enlist the characteristics of pl/sql?

0 Answers  

---

Explain the purpose of %type and %rowtype data types?

0 Answers  

---

---

What is dba in sql? : SQL DBA

0 Answers  

---

Can i use Commit inside the Trigger? Suppose i use commit what will be happy (it's complied /executed/work)

6 Answers  

---

What is t sql used for?

0 Answers  

---

What are two parts of package ?

2 Answers   Infosys,

---

What is difference between mysql and postgresql?

0 Answers  

---

how to extract a unit value from a date and time? : Sql dba

0 Answers  

---

Can we use pl sql in mysql?

0 Answers  

---