TRANSLATE This will replace the set of characters, character by character.To replace the single character at a time. Syntax: translate (string, old_chars, new_chars) Ex: select translate('india','in','xy') from dual; output translate('india','in','xy')…
RTRIM This will trim off unwanted characters from the right sides of string.This will remove all the specific characters from right side of string. Syntax: rtrim (string [, unwanted_chars]) Ex:…
LTRIM This will trim off unwanted characters from the left sides of string.This will remove all the specific characters from left side of string. Syntax: ltrim (string [,unwanted_chars]) Ex: select…
TRIM This will trim off unwanted characters from the both sides of string.This will remove all the specific characters from both side of string. Syntax: trim (unwanted_chars from string) Ex:…