oracle插入语句错误insert into basic_fileinfo(id,name) values(1,2) where 2 not in (select name
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)