sql 游标使用

   DECLARE
   CURSOR lappin IS 
   select id from lianxi;
   BEGIN 
   for usething in lappin loop
      update lianxi  
            set lianxi.enter_size = ( 
            select c.dic_code from ceshi c where c.dic_type =typeuse and c.dic_value = (
                   select s.dic_value from sys_dic s where s.dic_type = typeuse and s.dic_code = (
                          select lianxi.enter_size from lianxi where lianxi.id = usething.id
                          )
                   )
            ) where lianxi.id = usething.id;
   END LOOP;   
   END;

 更新操作