SQL command for UPDATE of multiple rows
Hi,
how to write SQL command to updating multiple rows in one statement? I tried as follows from TOAD which worked:
UPDATE TableA SET a = 'x' WHERE b = 'a';
UPDATE TableA SET a = 'x' WHERE b = 'b;
UPDATE TableA SET a = 'x' WHERE b = 'c';
UPDATE TableA SET a = 'x' WHERE b = 'd';
...
But when I created same command and runned it from my asp.net (C#) application it didn't work, how come? It cause an ORA-00911: invalid character problem.
My solution now is that I create one update command, insert into database, create next update command, insert into database, and so weither. This creates a lot of pressure on the server I guess and couldn't be the most effective way to write/run this update query.
Any ideas/recommendations how to solve above is highly appreciated.
Thx in advance.