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 vote332 views1 answer
Query to count the number of rows in a table in sqlalchemy
SQL
0 vote355 views1 answer
Postgres can integer fields be negative
SQL
0 vote324 views1 answer
How to get all values in a table mysql in c#
SQL
0 vote329 views1 answer
Mysqldump don't drop table
SQL
1 vote375 views1 answer
Nullif postgresql
SQL
0 vote367 views2 answers
Dbms transaction tutorialspoint
SQL
0 vote330 views1 answer
Sql anywhere create procedure
SQL
0 vote381 views2 answers
Disallowed function mysql to_date()
SQL
0 vote335 views1 answer
Min and max salary and name in sql
SQL
3 votes345 views2 answers
Oracle privileges users
SQL