OraFAQ Forum: SQL & PL/SQL » How to join 2 update statements

Home » SQL & PL/SQL » SQL & PL/SQL » How to join 2 update statements

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to join 2 update statements [message #424349]

Thu, 01 October 2009 12:29

lamnguyen14
Messages: 119
Registered: March 2007
Location: Virginia

Senior Member

Hi.

I have 2 update statements like below. Would you please to show me if there is any way I can join them in one statement? I would appreciate that.

UPDATE emp a 
SET salary = '9999'
WHERE id = (SELECT id FROM emp1 b
            WHERE a.ID = b.id AND b.status = '0');
    
UPDATE emp a 
SET salary = '8888'
WHERE id = (SELECT id FROM emp1 b
            WHERE a.ID = b.id AND b.status = '1');

Thank you very much.
LN

Report message to a moderator

Re: How to join 2 update statements [message #424350 is a reply to message #424349]

Thu, 01 October 2009 12:49

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

A single update statement with a decode or case statement would do the trick. something like

update emp a set salary = (select decode(status,0,...

Are you really storing salary as a character string?

[Updated on: Thu, 01 October 2009 12:53]

Report message to a moderator

Re: How to join 2 update statements [message #424351 is a reply to message #424349]

Thu, 01 October 2009 12:52

lamnguyen14
Messages: 119
Registered: March 2007
Location: Virginia

Senior Member

Thanks much.

Report message to a moderator

Previous Topic:	VARCHAR2 problem
Next Topic:	Difference between Varchar2/Char and CLOB

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 03 18:12:40 CST 2024