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

0 vote233 views2 answers
What is the default password for sql server sa
SQL
14 votes198 views2 answers
How to auto increment in sql
SQL
11 votes227 views3 answers
Sql line numbers
SQL
1 vote208 views1 answer
Clear screen command in psql
SQL
1 vote194 views1 answer
Sql myisam vs innodb
SQL
1 vote201 views1 answer
Where date = max(date) in sql
SQL
32 votes246 views6 answers
Rename column mysql
SQL
6 votes203 views2 answers
Mysql first day of month
SQL
0 vote196 views1 answer
Select STR_TO_DATE(date_seance1,'DD-MM-YYYY')
SQL
7 votes207 views1 answer
Mysql iif
SQL