oracle有条件执行插入语句 oracle 后面跟条件进行插入操作: insert into table_name (id,name ) select '1', '2' from dual where not exists ( SELECT id FROM table_name WHERE (id = '1')); 记录一下