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 vote102 views1 answer
Mysql show category once count how many products
SQL
0 vote112 views1 answer
Sql count null values in all columns
SQL
0 vote120 views1 answer
Mysql change timestamp on update
SQL
6 votes112 views1 answer
Update left join mysql
SQL
0 vote101 views1 answer
Where in clause tsql
SQL
0 vote68 views1 answer
Select all domains of database firbird
SQL
0 vote123 views1 answer
Pgadmin save data greyed out
SQL
0 vote111 views1 answer
Sql convert float to string
SQL
0 vote103 views2 answers
Oracle create tablespace autoextend
SQL
8 votes106 views2 answers
Mysql get first x characters
SQL