Question

oracle 中 insert into...if Exists(....)

if not exits (select * from Tab1 where extno = '119') insert into Tab1(ID,EXTNO)values (fn_get_uni_id('Tab1',1),'119');

要实现:如果Tab1表中extno字段中没有119这个记录,那么就插入119的记录.ID字段加一;
初次使用oracle.
thanks;

Answer 1

v_count number;
select count(*) into v_count from Tab1 where extno = '119';
if v_count=0 then
into Tab1(ID,EXTNO)values (fn_get_uni_id('Tab1',1),'119');
commit;
end if;

Answer 2

merge into tab1(in,extno) using (fn_get_uni_id(tab1,1),119) on (select * from Tab1 where extno = '119')

大致是这样的吧