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 vote283 views1 answer
Check command
SQL
0 vote325 views1 answer
SQLSTATE[42000]: Syntax error or access violation: 1140 Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
SQL
0 vote286 views1 answer
Spring Flyway Teams Edition or MySQL upgrade required: MySQL 5.5 is no longer supported by Flyway Community Edition, but still supported by Flyway Teams Edition.
SQL
0 vote280 views1 answer
Get current date data in mysql
SQL
0 vote260 views1 answer
Syntax for changing column size in mysql
SQL
0 vote294 views2 answers
How to truncate all table in mysql workbench
SQL
0 vote279 views1 answer
How to delete duplicate rows in oracle
SQL
0 vote277 views1 answer
Change permission to database mysql
SQL
7 votes339 views2 answers
Drop index oracle
SQL
6 votes262 views1 answer
Check Table Exists
SQL