Answer / anil kumar jampana

cursor is a private sql area. pl/sql cann't handle multy
row select statements. Inorder to handle mulyrow select
statements, we are using cursors.

Answer / raam

Cursor is a private memory area. to perform transations on
morethan one row we are using cursors. required multi-
records will be fetched to cursor area and will do
operations on those records. It is a temperary memory area.
Winthout Cursor pl/sql can perform only one record at a
time.

Answer / suresh

cursor is private sql area. cursor is used for to retrieve
or display the more than one values at a time.

what are the demerits of sql?

1 Answers  

---

What are the ways on commenting in a pl/sql code?

0 Answers  

---

What is compilation error in pl sql?

0 Answers  

---

What are analytic functions in sql?

0 Answers  

---

What are the advantages of VIEW?

5 Answers  

---

What is nested table in pl sql?

0 Answers  

---

Why is partition used in sql?

0 Answers  

---

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 is cursor and its types?

0 Answers  

---

What is different between union and minus?

7 Answers   Accenture, TCS,

---

how to increment dates by 1 in mysql? : Sql dba

0 Answers  

---

How many types of primary keys are there?

0 Answers  

---