我这个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)