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 vote298 views1 answer
Xampp mysql version
SQL
1 vote340 views1 answer
Mysql select row max date
SQL
8 votes310 views2 answers
Python simple connect to mysql
SQL
0 vote287 views1 answer
Oracle archivemode
SQL
0 vote287 views1 answer
Automate mysql cli query
SQL
0 vote330 views1 answer
Sql injection payload list github
SQL
0 vote310 views1 answer
Mysql min value row
SQL
0 vote301 views1 answer
Postgress append string in select
SQL
0 vote340 views1 answer
Datatables server side filter where clause
SQL
0 vote292 views1 answer
Delete double on SQL with multiple primary keys
SQL