Use of Lpad functions in Oracle _oracle

Usage of Lpad in Oracle

Pad translation: Filling
Lpad function, add the specified string to the left of the string, using:
Www.jb51.net
Lpad (string, intercept length, added string).

It is not accurate to add a string, but it is more accurate to say that a string is intercepted,
If the interception length is greater than the length of a string, the
String to fill the left with a space, if the third argument is not specified.

For example:
Select Lpad (' Test ', ten) from dual;

will return "test"
Select Lpad (' Test ', ten, ' EE ') from dual;
The result is returned to Eeeeeetest.