Replacing characters at specific positions in strings in Oracle

Question

I'm trying to write a function that can decode a message by switching pairs of characters around.

Say I have the message hello! which, when encoded, turns into ehll!o. Is there an existing function in Oracle that lets me replace characters at specified positions with other characters of my choosing?

Egor Skriptunoff · Accepted Answer · 2013-05-17 10:20:19Z

9

You should use regex that looks like a tits:

regexp_replace(string, '(.)(.)', '\2\1')

fiddle

answered May 17, 2013 at 10:20

Egor Skriptunoff

23.8k2 gold badges38 silver badges68 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

David Aldridge · Accepted Answer · 2013-05-17 10:14:43Z

1

You'd be looking for SubStr() I believe. Possibly Translate() or Replace().

answered May 17, 2013 at 10:14

David Aldridge

52.5k8 gold badges73 silver badges99 bronze badges

Comments

rcp · Accepted Answer · 2020-06-11 07:58:09Z

0

If you want to simply mask few characters from a particular position, you could like below

SUBSTR(field_name,1,4) || 'XXXX' || SUBSTR(field_name,LENGTH(field_name)-4,LENGTH(field_name))
as field_name

If the field values is 0007125009300 Output will be 0007XXXX09300

answered Jun 11, 2020 at 7:58

rcp

3114 silver badges11 bronze badges

Collectives™ on Stack Overflow

Replacing characters at specific positions in strings in Oracle

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related