LPAD

LPAD adds characters to the left of an expression to a specified length.

Use RPAD to add characters to the right.

Return Value

VARCHAR2 | CLOB

Syntax

LPAD(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

LPAD('Page 1',15,'*.') returns the value *.*.*.*.*Page 1.

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