How to use LPAD and RPAD Function

If you want to pad any character on the left side or right side of a string, you can use LPAD and RPAD functions. In this article you will see how to use LPAD and RPAD functions in Oracle.

LPAD and RPAD function

LPAD function:

The LPAD function is used to pad the left side of a string with a specific set of characters.

LPAD Syntax:

The syntax for the LPAD function is:


LPAD( string_to_pad, padded_length, [ pad_string ] )

String_to_pad is the string to pad characters to the left hand side.

padded_length is the number of characters to pad in the string. If the padded_length is smaller than the original string, the LPAD function will truncate the string to the size of padded_length.


pad_string is the optional field. This is the string that will be padded to the left hand side of String_to_pad. If this parameter is absent, the LPAD function will pad spaces to the left side of String_to_pad.

Examples:

The LPAD function can be used in Oracle SQL and PLSQL:

SQL> select LPAD('ITBloggerTips',15) from dual;

LPAD('ITBLOGGER

---------------

'  ITBloggerTips'

SQL> select LPAD('ITBloggerTips',9) from dual;

LPAD('ITB

---------

ITBlogger

SQL> select LPAD('ITBloggerTips',15,'0') from dual;

LPAD('ITBLOGGER

---------------

00ITBloggerTips

SQL> select LPAD('ITBloggerTips',20,'A') from dual;

LPAD('ITBLOGGERTIPS'

--------------------

AAAAAAAITBloggerTips

SQL> select LPAD('ITBloggerTips',9,'A') from dual;

LPAD('ITB

---------

ITBlogger

SQL> select LPAD('ITBloggerTips',13,'A') from dual;

LPAD('ITBLOGG

-------------

ITBloggerTips

SQL>

RPAD Function:

The RPAD function is used to pad the right side of a string with a specific set of characters.

RPAD Syntax:

The syntax for the RPAD function is:

RPAD(string_to_pad, padded_length, [ pad_string ])

String_to_pad is the string to pad characters to the right hand side.

padded_length is the number of characters to pad in the string. If the padded_length is smaller than the original string, the RPAD function will truncate the string to the size of padded_length.

pad_string is the optional field. This is the string that will be padded to the right hand side of String_to_pad. If this parameter is absent, the RPAD function will pad spaces to the right side of String_to_pad.

Examples:

The RPAD function can be used in Oracle SQL and PLSQL:

SQL> select RPAD('ITBloggerTips',15) from dual;

RPAD('ITBLOGGER

---------------

ITBloggerTips

SQL> select RPAD('ITBloggerTips',9) from dual;

RPAD('ITB

---------

ITBlogger

SQL> select RPAD('ITBloggerTips',15,'0') from dual;

RPAD('ITBLOGGER

---------------

ITBloggerTips00

SQL> select RPAD('ITBloggerTips',20,'A') from dual;

RPAD('ITBLOGGERTIPS'

--------------------

ITBloggerTipsAAAAAAA

SQL> select RPAD('ITBloggerTips',9,'A') from dual;

RPAD('ITB

---------

ITBlogger

SQL> select RPAD('ITBloggerTips',13,'A') from dual;

RPAD('ITBLOGG

-------------

ITBloggerTips

SQL>

If you know more about it, write below in comment section.

SiteGround Black Friday Sale Below Banner

Get Free Blogging Tips & Technology updates in your Email !!!

Subscribe via RSS feed

The following two tabs change content below.
Anil Kumar
IT Blogger Tips focus on Blogging Tips, SEO Tips, Social Media, SQL Tips, PL/SQL Tips, Oracle DBA, Linux/Unix, Latest Technology, How Tos and Technical Solutions. You can find us on Facebook | Twitter |
Find on Google+

Siteground SALE
70% OFF SiteGround WordPress Hosting – $2.95/month (Exclusive Offer !!!)