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
|
|