RPAD|V4.4.2|OceanBase Database| docs|Distributed Database

RPAD

Last Updated：2026-04-02 06:23:58 Updated

Purpose

RPAD() right-pads char1 with char2 to n characters in length.

If char1 is longer than n characters, the function returns the leftmost n characters of char1.
If char1 is shorter than n characters, and the combined length of char1 and char2 is greater than n characters, the function returns the leftmost n characters of the padded string.
If char1 is shorter than n characters, and the combined length of char1 and char2 is smaller than n characters, the function returns the leftmost n characters of a string obtained by padding char1 with char2 replicated for multiple times, where the total length of the string is greater than or equal to n characters.

RPAD(char1,n[,char2])

Parameter	Description
char1	The source string. It can be of the `CHAR`, `VARCHAR2`, `NCHAR`, `NVARCHAR2`, or `CLOB` data type.
n	The total length of the returned string after padding. It must be of the `NUMBER` data type or any data type that can be implicitly converted to the `NUMBER` data type. Note: A non-integer value is rounded down to an integer.
char2	The string to be padded with. The default value is a blank space. It can be of the `CHAR`, `VARCHAR2`, `NCHAR`, `NVARCHAR2`, or `CLOB` data type.

If char1 is of the character data type, the return type is VARCHAR2.
If char1 is of the national character data type, the return type is NVARCHAR2.
If char1 is of the LOB data type, the return type is LOB.

The following example right-pads the string ABCDE with asterisks (*) to 10 characters in length.

obclient> SELECT  RPAD('ABCDE',10,'*') "RPAD" FROM DUAL;
+------------+
| RPAD       |
+------------+
| ABCDE***** |
+------------+
1 row in set