Rpad: makes a string a certain length by adding (padding) a specified set of characters to the right : RPAD « Char Functions « Oracle PL / SQL






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

Rpad: makes a string a certain length by adding (padding) a specified set of characters to the right

 

SQL> -- Rpad: makes a string a certain length by adding (padding) a specified set of characters to the right .
SQL>
SQL> -- RPAD(string, length_to_make_string,  what_to_add_to_right_of_string)
SQL>
SQL> SELECT RPAD('Letters', 20, '.') FROM dual;

RPAD('LETTERS',20,'.
--------------------
Letters.............








Related examples in the same category

1.LPAD() and RPAD(): pad the input parameter of character data types with blanks (or another character) from the left or right
2.RPAD() function's behavior is identical to that of LPAD(), the only difference being the padding side.
3.select rpad( '*', 5, '*' )
4.Use rpad to add extra space
5.Padding department with < and >