Oracle merge insert if not exists

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);

Source: stackoverflow.com

Similar codes

0 vote199 views1 answer
What is top n result in sql
SQL
1 vote222 views1 answer
Mysql return text after a final full stop
SQL
3 votes214 views3 answers
Mysql auto increment after delete
SQL
3 votes194 views2 answers
Order by postgresql
SQL
0 vote285 views1 answer
Mysql update table from select on another table
SQL
0 vote184 views1 answer
Get employees if not contains in sql
SQL
0 vote182 views1 answer
Sql query contains multiple ids
SQL
0 vote224 views1 answer
How to print some string in mysql
SQL
0 vote183 views1 answer
Sql case when exists in another table
SQL
0 vote215 views1 answer
What is common table expression in sql
SQL