What is the difference between cursor and stored procedures

Description of the illustration procedure3. The New Package window reappears. In the New Package window, click OK to save the new package. Description of the illustration procedure4.

Description of the illustration procedure5. Description of the illustration procedure6. The Output window appears, showing that the run was successful. Description of the illustration procedure7. Description of the illustration procedure8. Modifying an ODP. With Form1 selected, switch to code view. Output; cmd. Output cmd. To run a stored procedure: Run the application. Save Article. Improve Article. Like Article. Previous Layers of Abstraction in Computer System.

Next Applications of Real-time System. Recommended Articles. Article Contributed By :. Easy Normal Medium Hard Expert. Writing code in comment? Please use ide. There is much debate and documentation on this subject as well that is easily accessible.

My advice would be to forget you learned the syntax for cursors. Cursors are the last resort technique and should only be used by an expert who understnds what impact the cursor will have on performance and why the set-based alternatives won't work in his specific case. Most things done in cursors are far more easily done in a set-based fashion if you understand set operations. This link will help you learn what you need to know so that you will only rarely have to write a cursor:.

CURSOR: do something that is to be done row by row and not possible with simple query for example, if you have a temporary table to store hierarchy of categories, cursor can be useful to populate it. A function or procedure is a set of instructions to perform some task.

A cursor is an array that can stores the result set of a query. Stored procedures are pre-compiled objects and executes as bulk of statements, whereas cursors are used to execute row by row.

For Example: You can take cursors like a bag cursors are similar to pointer that points out on a single row out of so many rows and put all the result of a query run from within procedures, whenever you will need the results, just open the bag and find out the results row by row. Stack Overflow for Teams — Collaborate and share knowledge with a private group.

Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Asked 11 years, 5 months ago. Active 6 years, 2 months ago. Viewed 12k times. Improve this question. Add a comment.