length function

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;…