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 vote236 views1 answer
Oracle sql all days except weekends
SQL
0 vote190 views1 answer
Uncaught PDOException: SQLSTATE[HY000] [1698]
SQL
1 vote151 views1 answer
Mysql select row with max value group by
SQL
0 vote145 views1 answer
How to check if there is no database schema
SQL
0 vote173 views1 answer
Show all sequences postgres
SQL
0 vote149 views1 answer
SQL Server rename foreign key constraint
SQL
0 vote145 views1 answer
Sql insert tuple
SQL
0 vote177 views1 answer
SQLSTATE[42S02]: Base table or view not found: 1146 Tabl
SQL
0 vote178 views1 answer
Sql set data from a select query to a temp table and insert
SQL
9 votes183 views4 answers
Oracle get table column names
SQL