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

24 votes262 views6 answers
Rename a column in sql server
SQL
0 vote251 views1 answer
Sql server cannot create database diagram
SQL
19 votes256 views4 answers
Rename database in sql
SQL
0 vote241 views2 answers
Which MySQL statement is used to delete data from a database
SQL
-1 vote272 views3 answers
My sql alter table
SQL
6 votes265 views2 answers
Postgresql pg_dump
SQL
0 vote253 views1 answer
Output table plsql
SQL
2 votes225 views1 answer
Latest record in sql
SQL
13 votes271 views2 answers
Sqlite rename table
SQL
0 vote258 views2 answers
How to combine diff colmun value using group by postgres
SQL