日期:2014-05-17  浏览次数:20812 次

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)