Timeline for Replacing a specific string in oracle
Current License: CC BY-SA 4.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jan 31, 2021 at 18:37 | comment | added | Vérace | I extensively revised my answer - you might want to take a look? I believe that I've covered all the bases - if not, let me know! | |
| Jan 31, 2021 at 18:34 | history | edited | Vérace | edited tags | |
| Jan 31, 2021 at 11:16 | comment | added | Andrew Sayer | Your statements look ok to me (the first is going to be slower as you’re running an additional subquery per row when you already have all the information needed). The second statement is what I would write. I suggest querying the row before and after your update to prove that this update statement is not responsible for doubling up the 'Company Cancelled' bit. | |
| Jan 31, 2021 at 9:45 | answer | added | Vérace | timeline score: 3 | |
| Jan 31, 2021 at 9:04 | history | edited | Aravind | CC BY-SA 4.0 | edited body |
| Jan 31, 2021 at 8:42 | history | asked | Aravind | CC BY-SA 4.0 |