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 vote214 views1 answer
Oracle user last connection date
SQL
0 vote217 views2 answers
Sql query in dax power bi
SQL
24 votes214 views5 answers
Sql server insert into select
SQL
0 vote211 views1 answer
Systems sql
SQL
0 vote215 views1 answer
Find and replace database table phpmyadmin
SQL
8 votes201 views3 answers
Mysql alter table add index
SQL
0 vote218 views1 answer
Mysql root localhost run
SQL
0 vote239 views1 answer
Psql check table fields
SQL
0 vote176 views1 answer
Count char in java
SQL
0 vote222 views1 answer
Sql alter column name sql server
SQL