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 vote167 views1 answer
When mysql server would not work in xampp
SQL
1 vote178 views1 answer
Flask sqlalchemy filter multiple conditions
SQL
2 votes172 views1 answer
Set boolean flasksql
SQL
1 vote179 views2 answers
Remove space in mysql
SQL
8 votes174 views1 answer
Oracle search code in packages
SQL
0 vote188 views1 answer
How to run mysql in git bash
SQL
0 vote169 views1 answer
How to find username and password in oracle 18c
SQL
5 votes181 views3 answers
MySql get fields of table
SQL
13 votes177 views1 answer
Views in sql
SQL
2 votes184 views1 answer
Oracle convert run_duration to number
SQL