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!

Replacing Number with Asterisk

651686Jul 24 2008 — edited Jul 24 2008

Hi,

I am faced with the issue of replacing a number with an asterisk. For example, in my table, I want to be able to show an asterisk for every $100.

So for example, if Joe had a salary of $500, it would show:

Joe *****

How would I get my Oracle SQL to display this? Replace function? LPAD?

Thanks in advance.

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 21 2008

Added on Jul 24 2008

5 comments

1,628 views