SEARCH

 

LPAD Function

LPAD returns a VARCHAR2 string that is arg1 left padded with arg3 for a length of n.

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

Example:

SELECT LPAD('10 + signs',10,'+') as RESULT from DUAL;

RESULT
------------------
++++++++++10 + signs

Add your comments or share tips on Lpad

 

Top

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