Lpad usage in oracle

Oracle lpad usage pad Translation: Fill the lpad function, add the specified String on the left side of the String, usage: www.2cto.com lpad (String, capture length, added String ). It is not accurate to add a String. A more accurate statement is to intercept a String. If the intercept length is greater than the String length, add a String to the left of the String to fill the String, if the third parameter is not specified, use a space. For example: select lpad ('test', 10) from dual; "test" select lpad ('test', 10, 'ee ') from dual; the result returns eeeeeetest.
(Today, we see the two functions lpad and prior, and we know that we are very small)