Best Practice in Looping through the rows in a table

Hi there,

What is the best practice when it comes to iterating thru each row in a table?  Do I have to use CURSORS to achieve this or is there a better/more efficient way to do this?

I understand that using CURSORS is not a good programming practice.

For example, if I have a table that contains 500 rows or even maybe 5 million rows and i want to loop thru each row and then based on some logic as to perform some task.

thanks
Start Free Trial