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

-2 votes143 views1 answer
Use of where in left join in mysql
SQL
1 vote150 views1 answer
Mysql decimal allow negative values?
SQL
5 votes158 views1 answer
AND OR NOT operators sql
SQL
5 votes145 views2 answers
Mysql drop table cascade
SQL
0 vote149 views1 answer
How many rows affected in sqllite
SQL
9 votes146 views6 answers
Sql insert into
SQL
3 votes192 views1 answer
Oracle function
SQL
6 votes171 views1 answer
To count number of rows in SQL table
SQL
2 votes153 views1 answer
Query any digits record
SQL
4 votes180 views1 answer
Mysql query first character
SQL