oracle select into 的时候提示未找到数据

时间:2021-03-04 15:59:53
declare version varchar2(50);
begin
select version into version_id from 表a where 字段 = ''; --在select into 后面添加exception 错误处理机制
exception
when no_data_found then
version:= 'hhh '; --以上是处理select into 的时候提示未找到数据的处理方法
if version is null or version ='' then
INSERT INTO 表a (字段)
select NVL(max(VERSION),0)+1 from 表b ;
update 表3 set VERSION = (select NVL(max(VERSION),0) from 表a where 字段 = '' )
where 字段 = '';
commit;
end if;
end;