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 vote235 views1 answer
How to run mysql on terminal mac
SQL
0 vote225 views1 answer
Sql server order by nulls last
SQL
2 votes238 views1 answer
Oracle insert or update
SQL
1 vote250 views1 answer
Mysql count all table rows
SQL
3 votes231 views1 answer
Select sequence oracle
SQL
0 vote211 views1 answer
What is the essence of SQL?
SQL
0 vote211 views1 answer
Hive batch drop table
SQL
9 votes248 views6 answers
Oracle substring
SQL
0 vote243 views1 answer
Mysql Install Ubuntu with native password
SQL
-1 vote249 views1 answer
Brisanje dupliranih konatakata
SQL