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 vote303 views1 answer
2020 new year
SQL
0 vote312 views1 answer
Mysql coonect sample code
SQL
4 votes308 views2 answers
What is table in sql
SQL
6 votes327 views3 answers
Oracle all dates between two dates
SQL
0 vote321 views1 answer
Starting mysql shell lampp ubuntu
SQL
0 vote338 views1 answer
Sql commands in android
SQL
0 vote321 views1 answer
Mysql sql.gz
SQL
0 vote318 views1 answer
Sql get number of days between two dates
SQL
11 votes318 views1 answer
Mysql order by two columns priority
SQL
-1 vote313 views1 answer
Mac mysql workbench console
SQL