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 vote252 views2 answers
Suse stop MySQL
SQL
0 vote186 views1 answer
How to insert a uniqueidentifier in sql
SQL
4 votes196 views2 answers
Oracle unlock user
SQL
13 votes201 views3 answers
Uninstall mysql centos 7
SQL
0 vote227 views1 answer
Use mysql in java program
SQL
4 votes192 views2 answers
Sqlalchemy_database_uri for mysql
SQL
5 votes162 views1 answer
Alter table default value mysql
SQL
5 votes204 views3 answers
Sql max value in column
SQL
0 vote162 views1 answer
Import csv to mysql
SQL
0 vote146 views1 answer
How to connect sql server using ip address in c#
SQL