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

1 vote139 views1 answer
Sql select contem uma palavra
SQL
24 votes142 views4 answers
Mssql get all table names
SQL
3 votes135 views2 answers
Sql server current date without time
SQL
0 vote88 views1 answer
Sqlalchemy.exc.DBAPIError: (ibm_db_dbi.Error) ibm_db_dbi::Error: SystemError('<built-in function connect> returned NULL without setting an error')
SQL
3 votes140 views1 answer
How to find names includes in sql
SQL
1 vote154 views1 answer
How to get previous year from sysdate in oracle
SQL
8 votes138 views1 answer
Oracle add months to sysdate
SQL
0 vote139 views1 answer
Update and keep original value sql
SQL
7 votes135 views1 answer
Sql management studio display line numbers
SQL
13 votes161 views3 answers
Sql select from multiple tables without join
SQL