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 votes144 views3 answers
Oracle tablespace usage
SQL
1 vote244 views1 answer
Oracle current sequence value
SQL
1 vote170 views1 answer
Oracle activate job
SQL
9 votes146 views4 answers
Mysql show table fields
SQL
2 votes164 views3 answers
How do I add a user to a postgres database? cli
SQL
1 vote153 views1 answer
Are NULL values in a database the same as that of blank space or zero?
SQL
0 vote171 views1 answer
Postgressql uuid
SQL
-1 vote144 views1 answer
Sql add column bit
SQL
0 vote137 views1 answer
Get all employee of salary if more than in sql
SQL
1 vote138 views1 answer
Oracle explain plan
SQL