Sitemap
 

Oracle LPAD() RPAD() Functions

LPAD(char, n[,PadChar])
              Left Pad char with n spaces [or PadChars]

select LPAD('Earn Money',4)  from dual
result :Earn


select LPAD('Earn Money',16,'*')  from dual

Result :******Earn Money

 

LPAD(char, n[,PadChar])
              Right Pad char with n spaces [or PadChars]

select RPAD('Earn Money',16,'*')  from dual
Result :Earn Money******

   
Page  1
 
Earn Money
Make Web Sites
Free Web Tools
Most searched EBooks
Help us to maintain this site free
© Copyright 2004-2007 www.easywebtech.com   
All Rights Reserved.   
Privacy policy
Earn Money with adsense Adsl wifi

technorati technorati