Replace the line break

TRANSLATE function replaces a sequence of characters in a string with another set of characters. However, it replaces a single character at a time.

The syntax for the TRANSLATE function in Oracle/PLSQL is:

TRANSLATE( string1, string_to_replace, replacement_string )

parameters or Arguments

string1

The string to replace a sequence of characters with another 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 replaced with the corresponding character in the replacement_string.