What is the use of Translate Function in Oracle?

Options
- performs a word wise replacement of a string of numbers
- performs a character wise replacement of a number
- performs a word wise replacement of a string
- performs a character wise replacement of a string

CORRECT ANSWER : performs a character wise replacement of a string

Discussion Board
Translate function

Translate function performs a character wise replacement of a string. This function replaces a sequence of characters in a string with another set of characters. However, it replaces a single character at a time. This function does not support CLOB data directly. However, CLOBs can be passed in as arguments through implicit data conversion.

Prajakta Pandit 02-10-2017 01:59 AM

Write your comments


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Related Content

Advertisement
 
▲