Call RPAD function in PL/SQL : RPAD « Character String Functions « Oracle PL/SQL Tutorial

SQL>
SQL>
SQL> CREATE OR REPLACE FUNCTION rulerstr (len IN INTEGER) RETURN VARCHAR2
  2  IS
  3     digits CHAR(10) := '1234567890';
  4  BEGIN
  5     RETURN RPAD (digits, len, digits);
  6  END;
  7  /

Function created.

SQL>
SQL> select rulerstr(3) from dual;

RULERSTR(3)
----------------------------------------------------------------------------------------------------
123

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