DECLARE
L_X INT;
BEGIN
SELECT COUNT(*)
INTO L_X
FROM C_RCA_CONS_TEMP
where cons_no = '3508089402';
IF L_X > 0 THEN
update C_RCA_CONS_TEMP
set cons_no = '3508089402',
org_no = '623080501',
cons_name = '小明',
cert_type_code = '居民身份证'
where cons_no = '3508089402';
else
insert into C_RCA_CONS_TEMP
values
('3508089402', '623080501', '小明', '居民身份证');
END IF;
COMMIT;
END;
Oracle DECLARE 函数更新数据若不存在则插入
最新推荐文章于 2022-09-26 16:54:16 发布