Oracle LPAD() Function

LPAD is a String function of Oracle. This function returns the left padded to the given length.

Syntax

Parameters

string1: string to be padded from left.

padded_length : length to be padded from left.

pad_string: it is optional. It is the string that will be padded from the left side of string1.

Return

This function returns the left padded to the given length.

Example 1


Oracle String LPAD() Function

Example 2


Oracle String LPAD() Function
Next TopicOracle String




Latest Courses