Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

usage of lpad

774995May 25 2010 — edited May 25 2010
hello 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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 22 2010
Added on May 25 2010
5 comments
828 views