How to insert characters in the right side of a string in oracle

In Oracle, RPAD function pads the right-side of a string with a specific set of characters.The syntax for the RPAD function is: RPAD( string1, padded_length, [ pad_string ] ).

For Example

SELECT RPAD('SHAHEER',12,*****) FROM DUAL;

RESULT: SHAHEER*****


Comments

Popular posts from this blog

What is Oracle Integration Cloud Service - ICS?

How to Create Packages in Oracle Database using TOAD for Oracle

How to create a Simple Scheduler Job in Oracle Database using Toad