Oracle insert or update

-- Oracle: Example for Insert or update in t1 from t2 values 
MERGE INTO table1 t1
USING table2 t2
ON (t1.CODE = t2.ID)
WHEN MATCHED THEN
    UPDATE SET t1.COL1 = t2.VALUE1
WHEN NOT MATCHED THEN
    INSERT (CODE, COL1)  VALUES (t2.ID, t2.VALUE1);

Similar codes

1 vote171 views1 answer
Sql headers delphi
SQL
2 votes171 views4 answers
Mysql select into new table
SQL
0 vote201 views1 answer
Python sql passer des parametres dans une requet pymysql
SQL
7 votes175 views2 answers
Execute mysql file
SQL
1 vote131 views1 answer
Alter user mysql native password
SQL
2 votes171 views1 answer
Mysql query unique column
SQL
12 votes162 views3 answers
Duplicate a column in sql
SQL
2 votes172 views1 answer
Query to find table size in oracle 12c
SQL
1 vote176 views1 answer
Check if mysql is installed
SQL
3 votes164 views2 answers
Plsql print
SQL