Skip to Main Content

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!

using translate function for one to many character translation

TiminNov 24 2011 — edited Nov 24 2011
Hi friends!


Can anybody tell me whether it is possible to use built in translate function for converting some text from a one alphabet to another one, if these alphabets are of different length. Something like

SELECT TRANSLATE('текст',
'АБВГДЕЕЖЗИКЛМНОПРСТУФХЦЧШЩЭЮЯ',
'ABCGDEF"*GH*"HIJKLMNOPQRSTYVWXYZ') FROM dual;

Or there is another function for this, or it is impossible?

Thanks
This post has been answered by Peter Gjelstrup on Nov 24 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 22 2011
Added on Nov 24 2011
6 comments
270 views