What is the usage of the RPAD function in Oracle?

6 months ago

2 minutes

In Oracle, the RPAD function is used to add a specified number of characters to the right side of a string in order to reach a specified length. The syntax is as follows:

RPAD(string, length, pad_string)

Parameter description:

string: the string to be filled
total length of the padded string
pad_string: character or string to use for padding

For example, if there is a string ‘Hello’ and you want to add spaces to the right to make the total length 10, you can use the following statement:

SELECT RPAD('Hello', 10, ' ') AS padded_string
FROM dual;

The result of the execution is:

padded_string
------------
Hello

In this example, the string ‘Hello’ is padded with 4 spaces on the right side, making its total length 10.