Horje
oracle merge insert if not exists Code Example
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



Sql

Related
php get closest location by latitude longitude Code Example php get closest location by latitude longitude Code Example
use of undefined constant mysql_assoc - assumed Code Example use of undefined constant mysql_assoc - assumed Code Example
dns slave zone convert Code Example dns slave zone convert Code Example
INSERT INTO table using OpenQuery Code Example INSERT INTO table using OpenQuery Code Example
MySQL PARTITION BY month automatically Code Example MySQL PARTITION BY month automatically Code Example

Type:
 Code Example
Category:
 Coding
Sub Category:
 Code Example
Uploaded by:
 Admin
Views:
 7



 

Horje