Oracle SQL - Function RPAD function

  1. HOME
  2. Oracle SQL
  3. Function
  4. 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  .  ja v  a  2  s.  c  om
SQL> SELECT RPAD('Test', 20, '.') FROM dual ;

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

SQL>