Question

if not exists...insert...如何改成oracle写法？

if not exists(select * from tablename where colname='***')
insert into tablename values('','','','','')

这是sql语句，在oracle里应该怎么写？

Answer 1

刚才找到一个更好的方法：
insert when (not exists (select * from tablename where colname = '***')) then
into tablename select '', '', '', '', '' from dual

Answer 2

insert into table select * from table1 where Not Exists (select * from table)

其实就这么简单！

祝你好运

Answer 3

if not exists(select * from tablename where colname='***') then
insert into tablename values('','','','','') ;
end if;