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 vote231 views1 answer
Md5 encryption for existing records
SQL
1 vote221 views1 answer
Local sql server
SQL
1 vote182 views1 answer
Oracle boolean to varchar
SQL
0 vote215 views1 answer
Postgresql CREATE EXTENSION pgcrypto
SQL
2 votes236 views1 answer
Oracle list grants on package
SQL
0 vote213 views1 answer
Mysql> grant all privileges on *.* to root@localhost identified by 'password' with grant option;
SQL
1 vote220 views1 answer
T-SQL Alter the column data type
SQL
0 vote226 views1 answer
Error-expression-select-list-not-group-by-nonaggregated-column/
SQL
0 vote247 views1 answer
Oracle insert single quote in string
SQL
0 vote235 views4 answers
How to connect form to database
SQL