Question: what is difference between stored procedure and cursor?
Answer: 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.