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 18c Express Edition Release 18.0.0.0.0 - Production | Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production Version 18.4.0.0.0 |
Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production | 0 |
SELECT REGEXP_REPLACE('Frédéric', '[^ -~]', '') FROM dual
| REGEXP_REPLACE('FRÉDÉRIC','[^-~]','') |
|---|
| Frdric |
SELECT REGEXP_REPLACE('QuÉbec', '[^ -~]', '') from dual
| REGEXP_REPLACE('QUÉBEC','[^-~]','') |
|---|
| Qubec |