关于replace函数 同时替换两个值如何操作

Question

如某字段project_name 如值为a 替换成aa 如值为b 替换成bb 应该怎样写select replace(project_name,'a','aa') from dual  那b替换到bb如何写呢

Answer 1

select replace(project_name,'a','aa','b','bb') from dual 

Answer 2

额！那别人要是还有cdefg呢？ 难道一个一个写？

Answer 3

select decode(project_name,
              'a','aaa',
              'b','bbb',
              'c','ccc',
              'zzz') project_name
from project

Answer 4

替换2次啊或者decode，case when
select replace(replace(project_name,'a','aa'),'b','bb') from dual

Answer 5

谢谢ls 不过还是改了下
select decode(project_name,
              'a','aaa',
              'b','bbb',
              'c','ccc',
              project_name) project_name
from project
因为默认值还是要返回字段原有的值