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 vote314 views1 answer
Mysql create table columns with spaces
SQL
2 votes332 views1 answer
Mysql select random id from table
SQL
0 vote360 views1 answer
Xamarin sql lite create table if not exist
SQL
11 votes363 views2 answers
You are using safe update mode
SQL
0 vote350 views1 answer
OFFSET consulta mysql
SQL
1 vote391 views1 answer
Find size of all DB's postgres
SQL
1 vote359 views1 answer
Select last row from SQL Table
SQL
44 votes402 views6 answers
Rename command in sql
SQL
3 votes331 views3 answers
Sql current year
SQL
0 vote337 views1 answer
What is mysql_pconnect
SQL