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)