insert ignore into table1
select 'value1',value2
from table2
where table2.type = 'ok'
When I run this I get the error "missing INTO keyword".
See Question&Answers more detail:osinsert ignore into table1
select 'value1',value2
from table2
where table2.type = 'ok'
When I run this I get the error "missing INTO keyword".
See Question&Answers more detail:osWhen I run this I get the error "missing INTO keyword" .
Because IGNORE is not a keyword in Oracle. That is MySQL syntax.
What you can do is use MERGE.
merge into table1 t1
using (select 'value1' as value1 ,value2
from table2
where table2.type = 'ok' ) t2
on ( t1.value1 = t2.value1)
when not matched then
insert values (t2.value1, t2.value2)
/
From Oracle 10g we can use merge without handling both branches. In 9i we had to use a "dummy" MATCHED branch.
In more ancient versions the only options were either :