how to replace inverse question mark in Oracle sql

jl66
jl66 used Ask the Experts™
on
The columns contain the inverse question marks. Want to replace them with a space. How to do that?

select c1 from t;

From ¿ aaaa ascd, this ¿ test
....
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2012
Distinguished Expert 2018
Commented:
Depending on the character sets involved, try this:
regexp_replace(c1,'[^[:alnum:]]') from t;
Database Administrator
Commented:
Or, the simple "replace" operator may work for you:

select replace(c1,'¿',' ') "C1_Spaced" from t1;
jl66Consultant

Author

Commented:
Thanks a lot.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial