SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Unable to replace/translate special characters in sql or pl/sql developer

VinipandaOct 11 2022

I have SQL developer of version 21.2 and PL/SQL developer of version 7.1.5
A simple query to replace special characters isn't working for a table.
Ex:

SELECT translate('à with a and è with e', 'àè', 'ae') FROM table;
or regexp_replace r even simple replace.

If i do same replace in dual table it works fine. Could there be issue in that particular table data?

Added on Oct 11 2022

#sql, #sqldeveloper

6 comments

1,865 views

1 mention