Rpad : RPAD « Character String Functions « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. Character String Functions
  3. RPAD

Add (padding) a specified set of characters to the right of the original string. RPAD stands for "right pad." The general format for this function is:

RPAD(string, length_to_make_string, what_to_add_to_right_of_string)

SQL> SELECT RPAD('Letters', 20, '.') FROM dual;

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

SQL>








11.12.RPAD
11.12.1.Rpad
11.12.2.RPAD(x, width [, pad_string]) pads x with spaces to right to bring the total length of the string up to width characters
11.12.3.RPAD() with number column
11.12.4.Call RPAD function in PL/SQL
11.12.5.Right padding the name of department
11.12.6.Use both lpad() and rpad() to create a string
11.12.7.Use RPAD to format cursor variable
11.12.8.Use rpad to represent the level
11.12.9.Use rpad function with define column default value
11.12.10.Use rpad to format a report