I have been given the task to update a few rows in adatabase. There are two columns in which one is
ID and the other is
CURRENCY. I have updated these rows using the update statements that follow:
update account set currency = 'INR' where id =15; update account set currency = 'EURO' where id =12; update account set currency = 'DOLLAR' where id =18; update account set currency = 'Pound' where id =13; -- and so on.
Actually, in this case I was able to do it easily using these update statements because of a relatively low number of rows, but what if there are thousands or lakhs (hundreds of thousands) of rows? Is this the only way to update them, or is there any alternate way or script?