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

rpad('computer',15,'*')
------------------------
computer*******
 rpad('computer',15,'*#')
--------------------------
 computer*#*#*#*
RPAD function in SQL
RPAD function in SQL
Default padding character was blank space.

Leave a Reply