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

-1 vote183 views1 answer
What is in operator
SQL
1 vote194 views1 answer
Sql list all procedures
SQL
0 vote202 views1 answer
Ver usuarios mysql
SQL
15 votes185 views7 answers
MYSQL
SQL
10 votes177 views3 answers
Insert into auto increment mysql
SQL
3 votes239 views1 answer
Oracle list invalid password logon denied
SQL
1 vote194 views1 answer
Float precision in psql
SQL
0 vote195 views1 answer
Sql server datetime to string
SQL
0 vote192 views1 answer
Sql getdate minus 1 day without time
SQL
0 vote201 views1 answer
Connect to nginx server mysql remotly
SQL