Sitemap
 

Oracle LTRIM() RTRIM() Functions

LTRIM(char[,set])
              Left Trim char - remove leading spaces [or char set]


select LTRIM('   Earn Money')  from dual

Result :Earn Money


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


RTRIM(char[,set])
              Right Trim char - trailing spaces [or char set]


select RTRIM('Earn Money*******','*')  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