The translate function replaces a sequence of characters in a string with another set of characters. However, it replaces a single character at a time. For example, it will replace the 1st character in the string_to_replace with the 1st character in the replacement_string. Then it will replace the 2nd character in the string_to_replace with the 2nd character in the replacement_string, and so on. You can use for translation from turkish character to english character.
Example
SQL> select translate(‘Yıldırım Şimşekoğlu’,’ıİşŞçÇöÖüÜ’,’iIsScCoOuU’) from dual;
Result : Yildirim Simsekoglu
SQL> select translate(’12test44′,’14’,’PL’) from dual;
Result : P2testLL
I really thank you. It works properly.