CODEWITHSUNDEEP
sqloracle-databasereplacecharacter
Yan
Yan

Reputation: 77

Replacing Any Character with Dots

I need to replace any character (following, say, 15th position) with two dots (for example). What's the function that should be used? "Substr" just cuts, "replace" searches for a specific string (and I need any key(s)... Thanks

Upvotes: 0

Views: 55

Answers (1)

sagi
sagi

Reputation: 40481

You can do 2 things, 1- use Reg expression as explained here: https://community.oracle.com/thread/895398?tstart=0

2- You can use your substr function and just cut it from 1-15 and concat it with two dots.

Upvotes: 1

Related Questions