SEARCH

 

RPAD Function

RPAD returns a VARCHAR2 string that is arg1 right padded with arg3 for a length of n.

If arg3 is not provided Oracle will pad with blank spaces.

Example:

SELECT RPAD('10 + spaces',10,'+') as RESULT from dual;

Add your comments or share tips on Rpad

 

Top

 
   Copyright © 2002-2008 OracleHome.co.uk All rights are reserved.