SQL 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:

          SQL> select rpad('computer',15,'*'), rpad('computer',15,'*#') from dual;

RPAD('COMPUTER'  RPAD('COMPUTER'

----------------------  ----------------------

computer*******    computer*#*#*#*

-- Default padding character was blank space.