This article is written about how to use the Oracle/PLSQL TRANSLATE feature with syntax and examples.
Description
The Oracle/PLSQL 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 exchange the 1st persona in the string_to_replace with the 1st persona in the replacement_string. Then it will replace the 2nd persona in the string_to_replace with the 2nd character in the replacement_string, and so on.
Syntax
The syntax for the TRANSLATE function in Oracle/PLSQL is:
TRANSLATE( string1, string_to_replace, replacement_string )Parameters or Arguments
string1 The string to substitute a sequence of characters with any other set of characters. string_to_replace The string that will be searched for in string1. replacement_string All characters in the string_to_replace will be changed with the corresponding persona in the replacement_string.
Returns
The TRANSLATE function returns a string value.
Applies To
The TRANSLATE characteristic can be used in the following versions of Oracle/PLSQL:
Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i, Oracle 8i
Example
Let’s seem to be at some Oracle TRANSLATE characteristic examples and explore how to use the TRANSLATE feature in Oracle/PLSQL.
For example:
TRANSLATE('1tech23', '123', '456')
Result: '4tech56'
TRANSLATE('222tech', '2ec', '3it')
Result: '333tith'