bank mergers
We have had a number of accounts created for BankA for a long time. BankB bought BankA a few years ago. Everything in Oracle still shows BankA's name but legally they're BankB now. After that we opened a new account with the same bank someone defined BankB as a new bank and created the new account under it. We have a request to show all these banks as BankB in Oracle. Is there a way to merge these or is there some other way to bring them together now without losing all the history?