Re: multiple updates in one statement

Hi Prasath,

it is very much possible with a single statement,

update test_table set my_col = decode(my_flag,'N',1,2);

Regards,

Samir Hegishte.

Prasath wrote:
> 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';
Received on Thu Jun 29 2006 - 08:19:37 CDT