Oracle RPAD function.

Preamble

The Oracle/PLSQL RPAD function supplements a certain character set from the right side of the string (at non-zero string1).

Syntax of the Oracle/PLSQL RPAD function

RPAD( string1_id, padded_length_id, [ pad_string_id ] )

Parameters and function arguments

• string1_id – string for adding characters (on the right side).
• padded_length_id – number of returned characters. If padded_length is smaller than the source string, the RPAD function will crop the line with padded_length.
• pad_string_id – it is not obligatory. It is a string that will be matched on the right side of string1. If this parameter is not specified, RPAD function will add spaces to right side of string1.

The RPAD function returns a string value.

RPAD function can be used in the following Oracle/PLSQL versions

Let’s consider some examples of RPAD function and learn how to use RPAD function in Oracle PLSQL.

SQL> SELECT RPAD('abcd', 7) FROM DUAL;

--Result: abcd

SQL> SELECT RPAD('abcd', 2) FROM DUAL;

--Result: ab

SQL> SELECT RPAD('abcd', 8, '0') FROM DUAL;

--Result: abcd0000.

SQL> SELECT RPAD('abcd ef ghi jkl', 15, 'z') FROM DUAL;

--Result: abcd ef ghi jkl

SQL> SELECT RPAD('abcd ef ghi jkl', 16, 'z') FROM DUAL;

--Result: abcd ef ghi jklz

How to Add Character using RPAD function in Oracle SQL Database

About Enteros

​​​​Enteros offers a patented database performance management SaaS platform. It proactively identifies root causes of complex business-impacting database scalability and performance issues across a growing number of clouds, RDBMS, NoSQL, and machine learning database platforms.​