update abit
set substr(trim(abit.name), 0, 2) = '大大'
where substr(trim(abit.name),0,2)='小小'表abitname字段存放的汉字比较长
报错误ora-00927 :缺少等号
set substr(trim(abit.name), 0, 2) = '大大'
where substr(trim(abit.name),0,2)='小小'表abitname字段存放的汉字比较长
报错误ora-00927 :缺少等号
set substr(trim(abit.name), 0, 2) = '大大'//这有错
where substr(trim(abit.name),0,2)='小小'你要么abit.name = '大大',
要么abit.name = '大大'||substr(trim(abit.name), 0, 2)
update abit
set substr(trim(name), 0, 2) = '大大'
where name like '小小%'
这样都报错 报错误ora-00927 :缺少等号
你的sql应该是:
update abit
set name= '大大'||substr(trim(name), 2)
where name like '小小%'