Skip Headers
Oracle® OLAP Expression Syntax Reference
Release 11.2

Part Number E23381-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

LPAD

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

Use RPAD to add characters to the right.

Return Value

CHAR | NCHAR | VARCHAR2 | NVARCHAR2

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.

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