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!

putting asterisk in middle of string

user8983130Nov 17 2014 — edited Nov 23 2014

Hi,

In one of my column having value of string like '12345678'.

Now i want not all of these value would be visible. So i would put * on some characters. After updating the value would be like:

'123***789'. Can any one advise how can i do the update????

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 21 2014
Added on Nov 17 2014
10 comments
9,447 views