By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
SELECT *
FROM v$version
| BANNER | BANNER_FULL | BANNER_LEGACY | CON_ID |
|---|---|---|---|
| Oracle Database 21c Express Edition Release 21.0.0.0.0 - Production | Oracle Database 21c Express Edition Release 21.0.0.0.0 - Production Version 21.3.0.0.0 |
Oracle Database 21c Express Edition Release 21.0.0.0.0 - Production | 0 |
CREATE TABLE t( col VARCHAR2(89) )
INSERT INTO t
VALUES('H'||CHR(38)||'#39;ello wor'||CHR(38)||'#177;ld')
1 rows affected
SELECT *
FROM t
| COL |
|---|
| H'ello wor±ld |
SELECT REGEXP_REPLACE(col,'&#\d+;') AS result
FROM t
| RESULT |
|---|
| Hello world |