We can pad a string from left or from right by using LPAD or RPAD function respectively. We will use some examples to understand how these functions works. Here we will take plus2net as our input sting.
Example of LPAD
The output is here
You can see we have plus2net of 8 characters long. To this we have added or Pad at left ( at starting ) so the resultant string is of total 13 chars length.
What if the required length is less than the original string?