By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select replace('I am not aware of any or potential that hasn’t yet been reported',' or ','/') from dual;
| REPLACE('IAMNOTAWAREOFANYORPOTENTIALTHATHASN’TYETBEENREPORTED','OR','/') |
|---|
| I am not aware of any/potential that hasn’t yet been reported |
select replace('I am not aware of any or potential that hasn’t yet been reported','’','''') from dual;
| REPLACE('IAMNOTAWAREOFANYORPOTENTIALTHATHASN’TYETBEENREPORTED','’','''') |
|---|
| I am not aware of any or potential that hasn't yet been reported |
select replace(replace('I am not aware of any or potential that hasn’t yet been reported',' or ','/'),'’','''') from dual;
| REPLACE(REPLACE('IAMNOTAWAREOFANYORPOTENTIALTHATHASN’TYETBEENREPORTED','OR','/'),'’','''') |
|---|
| I am not aware of any/potential that hasn't yet been reported |