我这个sql错在那里 ,求救
update abit
set substr(trim(abit.name), 0, 2) = '大大 '
where substr(trim(abit.name),0,2)= '小小 '
表abitname字段存放的汉字比较长
报错误ora-00927 :缺少等号
------解决方案--------------------update abit
set substr(trim(abit.name), 0, 2) = '大大 '//这有错
where substr(trim(abit.name),0,2)= '小小 '
你要么abit.name = '大大 ',
要么abit.name = '大大 '||substr(trim(abit.name), 0, 2)