gemini burj

 Profile Answers by gemini burj 

• Nov 18th, 2007

 

 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.

example select translate('1tech23', '123', '456') from dual will return the below
4tech56
1 will be translated to 4
2 with 5
and 3 with 6