Question

oracle数据库，求一个sql语句批量修改某个字段内容

现在有个customer表，里面有个customerid这个字段，里面的数据都是123xxxx这种格式的，要求写个sql语句批量把123改为8010

Answer 1

update customer set customerid='8010'||substr(customerid,4,length(customerid)-3);
commit;

Answer 2

update customer set customerid = '8010'|| substr(customerid,4)

Answer 3

UPDATE customer SET customerid=8010 WHERE customerid LIKE '123%'