Need help with MERGE statement
Hi all,
We are doing a code conversion from Sybase to Oracle, and a tool that we use for this purpose is generating an update statement
that is taking a long time. I was checking if I can improve it using the merge statement but am getting stuck due to a 'distinct' keyword. Can someone point out what I am missing? Original query and my equivalent are written below. My query works syntactically but b.ssm_id should not be included in the select distinct' part and so is not functionally equivalent. I want to get an functionally correct equivalent of original query using MERGE.
that is taking a long time. I was checking if I can improve it using the merge statement but am getting stuck due to a 'distinct' keyword. Can someone point out what I am missing? Original query and my equivalent are written below. My query works syntactically but b.ssm_id should not be included in the select distinct' part and so is not functionally equivalent. I want to get an functionally correct equivalent of original query using MERGE.
0