Re: multiple updates in one statement

Prasath schrieb:
> Is it possible to merge the below 2 update statements into one single
> statement.
>
> 1. update test_table set my_col = 1 where my_flag = 'N';
> 2. update test_table set my_col = 2 where my_flag != 'N';
Possible yes, but why would you do that? Lots of Greetings!
Volker

-- 
For email replies, please substitute the obvious.