String manipulation [message #664246] |
Mon, 10 July 2017 02:00 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/06a1264124841a429b09f39359ae443c?s=64&d=mm&r=g) |
praf1981
Messages: 3 Registered: July 2017
|
Junior Member |
|
|
Hi Team,
I want show the output of 'Praful' as 'P****l'.
I can do this by using below query:
select substr('Praful',1,1) || LPAD('*', length('Praful')-2,'*') || substr('Praful',-1,1)
from dual;
but is there any simple way to do it?
|
|
|
|
Re: String manipulation [message #664248 is a reply to message #664246] |
Mon, 10 July 2017 03:49 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
John Watson
Messages: 8937 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
If you have the Advanced Security Option available, you can use the Data Redaction facility to write the string according to circumstances. Being a declarative technique, you won't have to anything programmatically.
|
|
|
|