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…