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:…
LPAD This will allows you to pad the left side of a column with any set of characters. Syntax: lpad (string, length [, padding_char]) Ex: select lpad('computer',15,'*'), lpad('computer',15,'*#') from dual;…
RPAD This will allows you to pad the right side of a column with any set of characters.Syntax: rpad (string, length ,[ padding_char]) Ex: select rpad('computer',15,'*'), rpad('computer',15,'*#') from dual; output…
LENGTHThis will give length of the string.Syntax: length (string)Ex:SQL> select length('computer') from dual; output 8 Ex:SQL> select length('this is My home.') from dual; output 16
What is String Function in SQL ? SQL String function will be applied for each row and produces individual output for each row. Other wise String function called as character…