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