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 vote294 views1 answer
Sql join on a subquery
SQL
1 vote280 views1 answer
Postgres convert exisiting column to text
SQL
21 votes279 views3 answers
Average sql
SQL
0 vote313 views1 answer
Mysql update all record removing 2 hours from column
SQL
0 vote285 views1 answer
Plsql check for string in numeric
SQL
0 vote293 views1 answer
How to get parent and child record in single query using sql
SQL
19 votes289 views6 answers
What is mySQL
SQL
0 vote278 views1 answer
Mysql pv progres
SQL
0 vote305 views1 answer
How to install postgresql on wsl
SQL
2 votes292 views1 answer
How to insert string variable into sqlite database
SQL