See this: Why using cursors in PL/SQl ORACLE?

If you read down in the answers, there's a good, practical answer about what cursors are used for. (Don't forget to upvote your favorite!)