TRIM Function
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:…
0 Comments
October 29, 2020
LPAD Function in SQL
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;…
October 29, 2020
RPAD Function
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…
October 29, 2020