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 vote202 views1 answer
Trigger stock phpmyadmin
SQL
1 vote192 views2 answers
Mysql between
SQL
0 vote178 views2 answers
Sql server select first day of previous year
SQL
0 vote181 views2 answers
Unique key
SQL
0 vote178 views1 answer
Sql grant select only
SQL
0 vote185 views1 answer
Codeigniter MySQL - Issue with SELECT & GROUP BY
SQL
1 vote182 views1 answer
How to change owner in postgres
SQL
2 votes130 views1 answer
Oracle current date without time
SQL
0 vote188 views1 answer
Reset keys in sql
SQL
0 vote175 views1 answer
Oracle grant create job
SQL