Merge/Insert data into exist table column based on conditions using SQL or PLSQL from Procedure call

Team,
need to UPDATE exist table column based on the other column of same table with some logic.