What is the function of the RPAD function in Oracle?

9 months ago

Liam

1 minute

The RPAD function in Oracle is used to pad the right side of a string with specified characters until it reaches a certain length. Its syntax is:

RPAD(string, length, [pad_string])

In this case, the parameter “string” refers to the string to be filled, “length” denotes the length to be filled up to, and “pad_string” represents the character used for filling, typically a blank space.

For example, if you want to pad the string ‘abc’ to a length of 10 with ‘-‘ on the right side, you can use the following statement:

SELECT RPAD('abc', 10, '-') FROM dual;

This will return the string ‘abc——-‘.