Name
RPAD
Synopsis
The RPAD function adds characters to the end of a character string. It returns a string padded to the right (hence the “R”) to a specified length and with an optional pad string. The specification of the RPAD function is:
FUNCTION RPAD (string1IN VARCHAR2,padded_lengthIN NUMBER [,pad_stringIN VARCHAR2]) RETURN VARCHAR2
RPAD returns string1 padded on the right to
length padded_length with the optional character
string pad_string. If you do not specify
pad_string, then string1 is
padded on the right with spaces. You must specify the
padded_length. If string1
already has a length equal to padded_length,
then RPAD returns string1 without any additional
characters. If padded_length is smaller than the
length of string1, RPAD effectively truncates
string1, returning only the first
padded_length characters of the incoming
string1.
Let’s look at some examples of RPAD:
Display the number padded right with zeros to a length of 10:
RPAD ('55', 10, '0') --> '5500000000'I could also use TO_CHAR to convert from a number to a character (I don’t know off-hand why you would do this, but it’s good to remember that there are usually at least two or three ways to solve any problem):
TO_CHAR (55 * 10000000) --> '5500000000'
Display the number padded right with zeros to a length of 5:
RPAD ('12345678', 5) --> '12345'RPAD interprets its
padded_lengthas the maximum length of the string that it may return. As a result, it countspadded_lengthnumber of characters from the left (start ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access