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

[luca623]

如某字段project_name 如值为a 替换成aa 如值为b 替换成bb 应该怎样写

select replace(project_name,'a','aa') from dual 那b替换到bb如何写呢

[秋雨飘落]

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

[a726928296]

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

[luca623]

[Quote=引用 1 楼 zftang 的回复:]

select replace(project_name,'a','aa','b','bb') from dual
[/Quote]

这我早就试过了 是参数过多

[304的的哥]

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

[dut703]

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

[luca623]

[Quote=引用 4 楼 bobo12082119 的回复:]

SQL code

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