插入一个表,条件是如果插入的数据与该表指定字段相同则不操作,如果在相应字段下没有相同的数据则执行插入。
写了个sql 貌似不对,我该怎么写?insert into CC_FRIEND (FRIEND_NAME,FRIEND_ADDRESS,FRIEND_ZIP_CODE,FRIEND_PHONE,FRIEND_FAX,FRIEND_EMAIL,FRIEND_HOMEPAGE,FRIEND_NAME_EN,FRIEND_CONTACT)
values('易趣','上海','020','111','123','[email protected]','www.yicu.com','yiqu','gab') where '易趣' not in (select FRIEND_NAME from CC_FRIEND);数据都是模拟的......
写了个sql 貌似不对,我该怎么写?insert into CC_FRIEND (FRIEND_NAME,FRIEND_ADDRESS,FRIEND_ZIP_CODE,FRIEND_PHONE,FRIEND_FAX,FRIEND_EMAIL,FRIEND_HOMEPAGE,FRIEND_NAME_EN,FRIEND_CONTACT)
values('易趣','上海','020','111','123','[email protected]','www.yicu.com','yiqu','gab') where '易趣' not in (select FRIEND_NAME from CC_FRIEND);数据都是模拟的......
( v_FRIEND_NAME IN CC_FRIEND.FRIEND_NAME%type,
v_FRIEND_ADDRESS IN CC_FRIEND.FRIEND_ADDRESS%type,
..
)
is
v_flag number := 0;
begin
select count(1) into v_flag from CC_FRIEND where FRIEND_NAME = v_FRIEND_NAME;
if v_flag = 0 then
insert into CC_FRIEND...;
end if;
end proc_test;
/