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

10 votes167 views1 answer
Oracle dependency
SQL
17 votes186 views4 answers
Postgres list users
SQL
0 vote187 views1 answer
Get date from timestamp in mysql
SQL
2 votes172 views2 answers
Spring import sql
SQL
1 vote172 views1 answer
How to use a trigger to validate input data
SQL
0 vote180 views1 answer
Django mysqlclient connection string
SQL
0 vote204 views1 answer
Set classpath for mysql-connector.jar
SQL
0 vote207 views1 answer
Sqlcmd no headers
SQL
0 vote169 views1 answer
Mysql with
SQL
0 vote204 views2 answers
MySQL PARTITION BY month automatically
SQL