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

1 vote132 views1 answer
Sql string function update replace
SQL
6 votes135 views5 answers
Sql add months to date
SQL
0 vote136 views1 answer
Add timestamp column to existing table t-sql
SQL
4 votes136 views2 answers
Delete all table oracle
SQL
1 vote123 views1 answer
How to delete a record from sqlite in android
SQL
0 vote132 views1 answer
Sql tablo hangi sp de
SQL
13 votes128 views3 answers
Change data type postgresql
SQL
12 votes132 views4 answers
Mysql version
SQL
0 vote132 views1 answer
Amount of entries in a table psql
SQL
3 votes128 views4 answers
Order by desc postgres
SQL