oracle插入语句错误
insert into basic_fileinfo(id,name) values('1','2') where '2' not in (select name from basic_fileinfo)
此语句执行错误！错误在什么地方？

[解决办法]


insert into basic_fileinfo(id,name)
select distinct '1','2' from basic_fileinfo where '2' not in (select name from basic_fileinfo)