Sponsored Links
Oracle LPAD,RPAD,LTRIM,RTRIM
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
RPAD(char, n[,PadChar])
Right Pad char with n spaces [or PadChars]
select RPAD('Earn Money',16,'*') from dual
Result :Earn Money******
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
|
|