Oracle SQL - Function RPAD function

Introduction

RPAD function makes a string a certain length by padding a specified set of characters to the right.

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) 

Demo

SQL>
SQL>--  w w w  . j  av a  2s  .com
SQL> SELECT RPAD('Test', 20, '.') FROM dual ;

RPAD('TEST',20,'.')
--------------------
Test................

SQL>