Question asked by visitor kamana

How to update more than one row with a different value with in a single column by a single update query.

One possible way could be with the use of CASE statement where the column that needs to be updated depends on some other column value.

A small example:
-- Create the table
CREATE TABLE t_bh ( a NUMBER, b VARCHAR2(100))

-- Insert 3 values.
-- The column b in all the 3 records has 'ABC'.
INSERT INTO t_bh VALUES( 1, 'ABC')
INSERT INTO t_bh VALUES( 2, 'ABC')
INSERT INTO t_bh VALUES( 3, 'ABC')

UPDATE t_bh
SET b =
CASE WHEN a = 1 THEN 'ABC'
WHEN a = 2 THEN 'DEF'
WHEN a = 3 THEN 'GHI'
END ;

Now U have 3 different values updated for b column with a single query.
Not sure if this helps for your requirement.
Thanks.

using like we can update more than one row,with different value in column

Certainly using "case" we can update a row with different values !!!

not sure but try below one
considering emp s reference table,if deptno of type varchar

update emp
set deptno=decode(deptno,10,'ten',20,'twenty','thirty');

try below one
considering emp s reference table,if deptno of type varchar

update emp
set deptno=decode(deptno,10,20,20,30,30);