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

Create Tables in Oracle Database using TOAD

How to create Oracle stored Procedures using TOAD for Oracle

How to Create Packages in Oracle Database using TOAD for Oracle