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 vote156 views1 answer
How to select even id in sql
SQL
1 vote144 views1 answer
Oracle select first result
SQL
3 votes149 views3 answers
Update join
SQL
0 vote141 views1 answer
Sql server split string and insert into table select
SQL
0 vote149 views1 answer
Sql select all tables from database change url
SQL
2 votes176 views1 answer
Mariadb json select
SQL
0 vote154 views1 answer
Sql missing values
SQL
1 vote196 views1 answer
How to select random rows from a table
SQL
2 votes140 views1 answer
SQL IF ELSE
SQL
0 vote199 views1 answer
How to compile a function in oracle
SQL