usage of lpad
774995May 25 2010 — edited May 25 2010hello guys i am newbie ,
with emp table in ename colomn ,i want to get as same as steriks (*) as the length of each ename string length
for example
smith has five characters so i want *****smith like this
miller has six character so i want ******miller
tony has four character so i want ****tonty and so on for whole column with LPAD
hope all you understand my question.