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 vote343 views1 answer
Django mysqlclient connection string
SQL
23 votes366 views1 answer
How remove column in mysql
SQL
0 vote344 views1 answer
Original Query
SQL
0 vote386 views1 answer
Count columns psql(PostreSQL)
SQL
0 vote338 views1 answer
Drush SQLSTATE[HY000] [2002] No such file or directory
SQL
0 vote371 views1 answer
Cast float mysql
SQL
3 votes378 views2 answers
Sql end of month
SQL
3 votes376 views2 answers
Postgres download
SQL
0 vote371 views2 answers
Search stored procedures by name
SQL
1 vote345 views1 answer
Set statiscis on in sql server
SQL