Oracle sql merge

-- 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 vote77 views1 answer
Postgresql last element of array
SQL
0 vote217 views2 answers
Execute stored procedure without db set
SQL
7 votes132 views3 answers
Select latest entry in sql table
SQL
1 vote127 views1 answer
Sql group by error
SQL
0 vote159 views1 answer
Alter domain sql
SQL
0 vote126 views1 answer
Run sql script file and changes db name in this file using c#
SQL
6 votes161 views2 answers
Oracle compile trigger
SQL
2 votes255 views2 answers
MySql FULL OUTER JOIN
SQL
0 vote132 views2 answers
Mysql get routine parameter list
SQL
1 vote178 views1 answer
Get the User Name and Domain Name from an Email Address
SQL