L
lssgj
Unregistered / Unconfirmed
GUEST, unregistred user!
在客户表中我想把“E001”这样的客户编号变为“E0001”我用下面的语句怎么不行?
该咋写(oracle表):
update gadata0007.customer
set strcustomercode='E0'+right(strcustomercode,3)
而这样写却可以:
update gadata0007.customer
set strcustomercode='E0001'
where strcustomercode='E001'
下面的语句仍不行:
update gadata0007.customer
set strcustomercode='E0'+'001'
where strcustomercode='E001'
看来问题出在“+”上或是该用其他字符函数。我刚学SQL,请多指教
该咋写(oracle表):
update gadata0007.customer
set strcustomercode='E0'+right(strcustomercode,3)
而这样写却可以:
update gadata0007.customer
set strcustomercode='E0001'
where strcustomercode='E001'
下面的语句仍不行:
update gadata0007.customer
set strcustomercode='E0'+'001'
where strcustomercode='E001'
看来问题出在“+”上或是该用其他字符函数。我刚学SQL,请多指教