RPAD « Char Functions « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Char Functions
  3. RPAD
1.Rpad: makes a string a certain length by adding (padding) a specified set of characters to the right
2.LPAD() and RPAD(): pad the input parameter of character data types with blanks (or another character) from the left or right
3.RPAD() function's behavior is identical to that of LPAD(), the only difference being the padding side.
4.select rpad( '*', 5, '*' )
5.Use rpad to add extra space
6.Padding department with < and >