Oracle Lpad Functions

The syntax format of the oracle Lpad function is as follows: lpad (string, padded_length, [pad_string]) string to be filled; the length of the string after padded_length is filled, that is, the length of the string returned by the function, if the number is shorter than the length of the original string, the lpad function truncates the string into n characters from left to right. The pad_string string is an optional parameter, this string is to be pasted to the left of the string. If this parameter is not written, the lpad function will paste a space on the left of the string. Example: select lpad (0000000022, '0') from dual; Result 2200000000 select rpad (, '0') from dual; Result