Answer / suresh kumar somayajula

Cursor : It's a private SQL worksheet area where we can
execute SQL commands and processing information.
The purpose of the Cursor is, PL/SQL execution block will
process only one records means it will return only one
records.If we want to retrieve or process more number of
records we use the "Cursors".
These are of two types.
1. Implicit Cursor 2. Explicit cursors.

Thank you,
Suresh

Answer / aravind

Cursor is used to process multiple rows using pl/sql.

Answer / sri

mainly cursor is used to to process the multiple records
from database

Answer / selvaraj v , anna university c

Cursors allow row-by-row processing of the result sets.
Retrieve more than one rows from table or database to use
Curosrs.

Answer / chandu

to perform multiple rows accessing.

Explain ttitle and btitle.

0 Answers  

---

How do I create a sql database?

0 Answers  

---

Maximum how many triggers can we use in trigger and How to find out how many records it fetched.

1 Answers   TCS,

---

What is auto increment in sql?

0 Answers  

---

How to select 10 records from a table?

0 Answers  

---

---

Is oracel sql developer written in java?

0 Answers  

---

Why are cursors used?

0 Answers  

---

What is the difference between anonymous block and named blocks?

3 Answers  

---

SELECT category, type, AVG(price) FROM products GROUP BY category, type ORDER BY 1, 2 If there are three distinct categories in the "products" table, and each one has five different types, how many rows are returned by the query above? 1. 1 row 2. 3 rows 3. 5 rows 4. 8 rows 5. 15 rows

3 Answers  

---

How consistent is the view of the data between and within multiple sessions, transactions or statements ?

0 Answers  

---

What is sql query limit?

0 Answers  

---

What is constant in pl sql?

0 Answers  

---