String manipulation [message #664246] |
Mon, 10 July 2017 02:00 |
|
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 |
John Watson
Messages: 8938 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.
|
|
|
|