case when 里面使用regexp_replace 报错：ORA-00907: missing right parenthesis

Question

不知道哪里出错了，请大神指点，多谢

select
case when instr(A.sPrintAddress,’校区’) > 0 then regexp_replace(A.sPrintAddress,'校区.+','校区')
     when instr(A.sPrintAddress,’中心’) > 0 then regexp_replace(A.sPrintAddress,'中心.+','中心')
ELSE sPrintAddress END sPrintAddress

from BS_Class A

where A.SDEPTCODE = '16'
and A.dtBeginDate >= to_date('2019/06/01 00:00:00','yyyy-mm-dd hh24:mi:ss')
and A.dtBeginDate < to_date('2019/06/06 00:00:00','yyyy-mm-dd hh24:mi:ss')

Answer 1

试试改成这样，case when 的结果给个别名 ：

ELSE A.sPrintAddress END as last_PrintAddress