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 vote122 views1 answer
Tsql generate rows
SQL
1 vote138 views3 answers
How to pass password to mysql command line
SQL
0 vote144 views1 answer
Sql values not in another table
SQL
0 vote139 views1 answer
Vs 2019 connect to local mysql database
SQL
0 vote144 views1 answer
Alter check command
SQL
0 vote141 views1 answer
Mysql page segment
SQL
0 vote134 views1 answer
T sql less than date
SQL
0 vote144 views1 answer
Sql convert float to string
SQL
4 votes183 views2 answers
Sql select except null
SQL
2 votes141 views1 answer
Mysql time ago difference
SQL