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 |
Is it mandatory to make all the users log off while applying add-ons and s-notes as it is in the case of support packs?
How can a user be able to access only for Customizing requests even if assigned se01 and se10?.
Difference between SAPNote and Support package?
How to check Kernel, tp versions?
You want to transport users between different clients. How would you do that?
Is it recomendate by SAP if in Production have many client ? Please give me refrerence/notes ? Thanks, Agan
Suppose you have to integrate sap ecc 6.0 to aws cloud. How can you achieve this?
I want to change five dialog work processes into batch. Where can I do this?
I am facing error at the time of background job(SAP_WP_CACHE_RELOAD_FULLStep 001 started (program RWP_RUNTIME_CACHE_RELOAD, variant SAP&RELOAD_ALL, user ID DDIC) No component system chosen Job cancelled after system exception ERROR_MESSAGE Step 001 started (program RWP_RUNTIME_CACHE_RELOAD, variant SAP&RELOAD_ALL, user ID DDIC) Message no. 00550 please help me with this
Where to check for system logs of Sap application at os level?
how can we activated profile parameter for disable multiple logon? i have already tried parameter: login/disable_multiple_login_gui=1. but its not affect to sap system. pls give me some step.
Do you have done System copy? What are the steps?