I have done. Thank you Wayne.

Thank you very much mahesh. I am new to cursors. thats y I was getting trouble. I am very sorry to everyone.

thanks lowell

Thank you Mahesh.

I tried to myself and removed the cursors. but I wants to do without while loop also

Thanks for your responce. actually i copied somewhere that above code.