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 vote245 views1 answer
Mysql multiple count
SQL
0 vote241 views1 answer
Print hello world in plsql
SQL
10 votes252 views2 answers
Sql pagination offset
SQL
1 vote225 views2 answers
Postgresql backup and restore globals and data
SQL
-1 vote226 views1 answer
How to open blade file from blade in laravel
SQL
0 vote235 views2 answers
Sql query in dax power bi
SQL
0 vote237 views1 answer
Sql menampilkan data tabel
SQL
2 votes240 views1 answer
Drop all database tables oracle sql developer
SQL
0 vote245 views1 answer
How to check event scheduler status mysql
SQL
1 vote253 views1 answer
Oracle create as select
SQL