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 vote190 views3 answers
Above average salary in sql
SQL
0 vote194 views1 answer
Postgres create extension if not exists
SQL
1 vote203 views1 answer
Clear screen command in psql
SQL
0 vote203 views1 answer
Postpresql relation not found
SQL
2 votes227 views1 answer
Sql update \
SQL
0 vote203 views1 answer
Mysql query with sql to get the next row
SQL
7 votes220 views3 answers
SQL create a new table
SQL
0 vote224 views1 answer
What are the advantages of MySQL when compared with Oracle?
SQL
2 votes189 views1 answer
Sqlite show table indexes
SQL
3 votes250 views1 answer
Sql select second max
SQL