不知道哪里出错了,请大神指点,多谢
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')