The lpad function in oracle is explained in detail
- 2020-12-19 21:14:55
- OfStack
The use of lpad in oracle
pad translation: Fill
The lpad function adds a specified string to the left of the string.
www.ofstack.com
lpad(String, truncated length, added string).
It is not accurate to say that adding a string is also inaccurate. More accurate is to intercept the string of String.
If the interception length is greater than the length of String, then
To the left of String, add a string to fill, or a space to fill if the third parameter is not specified.
Such as:
select lpad('test',10) from dual;
Will return "test"
select lpad('test',10,'ee') from dual;
The result returns eeeeeetest.
pad translation: Fill
The lpad function adds a specified string to the left of the string.
www.ofstack.com
lpad(String, truncated length, added string).
It is not accurate to say that adding a string is also inaccurate. More accurate is to intercept the string of String.
If the interception length is greater than the length of String, then
To the left of String, add a string to fill, or a space to fill if the third parameter is not specified.
Such as:
select lpad('test',10) from dual;
Will return "test"
select lpad('test',10,'ee') from dual;
The result returns eeeeeetest.