//创建存储过程
CREATE OR REPLACE 
PROCEDURE newdata AS
BEGIN
declare
	  //定义变量
      str_1 varchar2(4000);
begin
   //循环遍历
   for row_aaa in (select id from new_user t ) loop
   //初始化
    str_1:='';
BEGIN
//buffer不受限制	
DBMS_OUTPUT.ENABLE(buffer_size => null); 
//执行查询语句
select  kk into str_1 from
	(select  name ||'' KK                           
	 from( select name as name from user
	where  id = new_id ) WHERE ROWNUM < 2 ); 
	//打印输出结果
	dbms_output.put_line(str_1 );
	update new_user set name = str_1 where id = new_id;
//抛出异常
EXCEPTION WHEN NO_DATA_FOUND THEN
	str_21 := '';
	update new_user set name = str_1  where id = new_id ;
commit;	
end;			 
END;

//创建存储过程
DROP PROCEDURE IF EXISTS `newdata`;				
DELIMITER ;;
CREATE PROCEDURE `newdata`()
BEGIN
	//声明变量，用于循环状态的标识
	 DECLARE done INT DEFAULT FALSE;
	 declare str_1 TEXT;
	 declare new_id TEXT;
	 DECLARE cur_list CURSOR FOR select id from new_user t;
	 //抛出异常
	 DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = true;
	 set str_1 ='';
	 //打开游标
	 OPEN cur_list;
	 read_loop : LOOP
	 //赋值操作
		FETCH cur_list INTO new_id;
		//控制循环
		IF done THEN
            LEAVE read_loop;
        END IF;		
			select  kk into str_1 from
			(select  name ||'' KK                           
	 			from( select name as name from user
				where  id = new_id ) WHERE ROWNUM < 2 )dm; 

if str_1  is not null THEN
		update new_user set name = str_1 where id = new_id;
		commit;			
end if;
	//重置游标 当查询结果为空时，程序继续执行
	SET done = false;   
	set str_1 = null;
	 END LOOP read_loop;
	CLOSE cur_list ;
END ;;
DELIMITER;-- 游标结束
//调用存储过程
CALL newdata();