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 vote122 views2 answers
Cascade syntax in sql
SQL
4 votes108 views1 answer
Oracle session date format
SQL
8 votes128 views3 answers
SQL column name
SQL
0 vote116 views1 answer
Sql server alter table add column datetime default current_timestamp
SQL
0 vote110 views2 answers
Clear window pl sql
SQL
11 votes107 views1 answer
Oracle insert into where
SQL
0 vote119 views1 answer
Oracle sql procedure return value
SQL
0 vote108 views1 answer
How many rows affected in sqllite
SQL
1 vote113 views1 answer
Alter table column size oracle
SQL
5 votes110 views1 answer
Oracle sysdate
SQL