RPAD

RPAD adds characters to the right of an expression to a specified length. The data type of the return value is the same as the original text.

Use LPAD to add characters to the left.

Return Value

CHAR | NCHAR | VARCHAR2 | NVARCHAR2

Syntax

RPAD(expr1 , n [, expr2 ])

Arguments

expr1 is a text expression for the base string.

n is the total length of the returned expression. If expr1 is longer than n, then this function truncates expr1 to n characters.

expr2 is a text expression for the padding characters. By default, it is a space.

Example

RPAD('Stay tuned', 15, '. ') returns the value Stay tuned. . .

RPAD('Stay tuned', 4) returns the value Stay.