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

1 vote335 views1 answer
Oracle create_program
SQL
0 vote337 views1 answer
SQLite3::SQLException: table "categories" already exists: CREATE TABLE "categories" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL
SQL
0 vote332 views1 answer
Sqlite löschen einer tabelle
SQL
0 vote326 views1 answer
Make a socket server to detect changes in mysql
SQL
0 vote331 views1 answer
USING THE NOT CONDITION IN SQL
SQL
3 votes342 views1 answer
Laravel database Using Named Bindings
SQL
0 vote338 views3 answers
Classement rang mysql 7
SQL
1 vote330 views1 answer
Sql not equal multiple columns
SQL
0 vote331 views1 answer
Mysql join only one column
SQL
1 vote298 views1 answer
Reutrn string after character sql
SQL