Multiple Updates
Home > IT Answers > Oracle > Multiple Updates
SamAvella
25 pts.
0
Q:
Multiple Updates
Oracle, Oracle Table
Hi, is there a way to update a table as follows:

update tabe_name set name=name1 where oldname=1
name=name2 where oldname=2
name =name3 where oldname=3;

Thanks,
Sam
ASKED: Mar 31 2009  2:26 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Carlosdl
29820 pts.
0
A:
 RATE THIS ANSWER
+1
Click to Vote:
  •   1
  •  0
  • AddThis Social Bookmark Button
You could use the DECODE function.

Something like this:

UPDATE table_name
 	SET name = decode(oldname,1,name1,2,name2,3,name3)
 	WHERE oldname in (1,2,3);
Last Answered: Mar 31 2009  2:34 PM GMT by Carlosdl   29820 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0