RPAD

RPAD adds characters to the right of an expression to a specified length.

Use LPAD to add characters to the left.

Return Value

VARCHAR2 | CLOB

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. . .

Copyright © 2003, 2007, Oracle. All rights reserved.