what is main benefits of cursor?
Answers were Sorted based on User's Feedback
Answer / guest
cursor is basically used for fetching the multi record...
Is This Answer Correct ? | 6 Yes | 0 No |
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.
Is This Answer Correct ? | 1 Yes | 0 No |
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.
Is This Answer Correct ? | 1 Yes | 0 No |
What is the R3 system startup and shutdown process?
Using Tc SGEN I have generated 74% job and later I have terminated the job. I wish to start generating from where it stopped I have refreshed but to no chance, nothing was done. How should I further proceed so as to complete the remaining job?
what is the difference with oracle 9i and 10g?
Dear Community Members, Could you please help me in solving a urgent problem ? Below is details:- On client side working on SAP GUI print setting in Billing printed copy are problematic...( The problem regarding the improper arrangement of Numerical figures in Excise Invoices )....for your knowledge for easying the problem solution:- 1. from other system when print given the print is ok 2. there is no problem in printer 3. Also reinstalled SAP GUI but of no use As per me, final solution will be re-install the windows ? any other efficient solutions to the problem ?
Can i lock a particular table.If yes then how ?
ABAP Service Pack level can be found in SPAM, but how to find the Java Stack Level?
What is the purpose of table USR02?
if java instance stop or failed so what action you will take?
What is process for applying patches?
What is central user administration and its uses?
How to add datafile using brtools?what are steps?
Have you done load balancing?