Answer / guest

cursor is basically used for fetching the multi record...

Answer / ashwin mane

Cursors do provide a number of benefits. These benefits
follow from the fact that if you do not use a cursor, the
entire result set must be transferred to the client for
processing and display:

1.Client-side memory - For large results, holding the
entire result set on the client can lead to demanding
memory requirements.
2.Response time -Cursors can provide the first few rows
before the whole result set is assembled. If you do not use
cursors, the entire result set must be delivered before any
rows are displayed by your application.
3.Concurrency control -If you make updates to your data
and do not use cursors in your application, you must send
separate SQL statements to the database server to apply the
changes. This raises the possibility of concurrency
problems if the result set has changed since it was queried
by the client. In turn, this raises the possibility of lost
updates.

Cursors act as pointers to the underlying data, and so
impose proper concurrency constraints on any changes you
make.

Answer / riyaz chaus

Cursor is client side memory to be used to perform bunch of sql transactions.it also use to perform to hold the result of operations like sorting,joining.
instead of doing single by single sql transaction we can creat the cursor and do multiple transaction at single time.

what is the difference between user buffer and table buffer?

1 Answers   IBM,

---

What is Hour Glass state? and how does it be resolved

2 Answers  

---

HOW TO TRANSPORT SAME REQUST TO MANY CLIENTS

4 Answers  

---

What are the differences between system refresh and client refresh?

9 Answers   Cap Gemini,

---

Hi i am Ramesh want to know that which course in sap is most suitable for my younger brother who has BSC qualification and is this course is job oriented

0 Answers   BSNL,

---

If I want only transaction data to be copied.What profile should I select, while doing local client copy within the same apllication server. Else is there any other way to perform above task?

2 Answers   TCS,

---

role of RFC connection in project scenarios

6 Answers  

---

Where the transport data files will be placed?

1 Answers  

---

why do we set Java Path in Environmental Variable.

3 Answers  

---

Kernel upgradation procedure?

1 Answers  

---

There is a requirement like a user role to be created and he must have rights to view(read rights) the transactions.How it will be created in PFCG

2 Answers  

---

How to define instances and operation modes?

3 Answers  

---