We have a database in which we store HTML / XML code in tables.
To implement small change in company’s name[ABC_CORP% to XYZ_CORP%], Web developers want to know
1. All occurrence of ABC_CORP% - In which table, which column. In short first to pinpoint it.
2. Later on they want to change all occurrence of ABC_CORP% to XYZ_CORP%
Main problem is few columns are CLOBs containing HTML/XML code.
Do anybody have something readily available
OR at least guide me towards the best approach