RPAD() function's behavior is identical to that of LPAD(), the only difference being the padding side. : RPAD « Char Functions « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Char Functions
  3. RPAD

RPAD() function's behavior is identical to that of LPAD(), the only difference being the padding side.

  
SQL>
SQL> SELECT
  2     RPAD('ABC',6,'***') result1,
  3     LPAD('ABC',4,'***') result2,
  4     RPAD('ABC',2,'***') result3
  5  FROM dual;

RESULT RESU RE
------ ---- --
ABC*** *ABC AB








Related examples in the same category

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.select rpad( '*', 5, '*' )
4.Use rpad to add extra space
5.Padding department with < and >