Thanks Lanthus, but If we can do same operation using select or other DML statement, then use of cursor should be avoided. For example
I can store the variable using following statement also
select @prodID=Prod from Product

I am trying to find specific situation where we 'have to' use the cursor