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 vote367 views1 answer
Play framework connection via windows sql server
SQL
1 vote269 views1 answer
Local sql server
SQL
0 vote243 views1 answer
Mysql does collate nopad recognize space
SQL
0 vote274 views1 answer
Call rest api from postgresql
SQL
8 votes305 views3 answers
Postgres database sizes
SQL
0 vote306 views1 answer
Joomla execute raw sql
SQL
0 vote269 views1 answer
Restore backupfile discourse
SQL
0 vote301 views1 answer
Python sql last insertend
SQL
0 vote255 views1 answer
Sqlalchemy.exc.OperationalError:
SQL
7 votes300 views1 answer
Oracle pagination query rownum
SQL