For presentation purposes you could create a view on top of the table
to_char the salary field and translate the numbers 0-9 to "*'

-----Original Message-----
From: Gururaj
[mailto:oracledba-ezmlmshield-x28507466.[Email address protected]
Sent: Thursday, October 07, 2004 12:22 AM
To: LazyDBA Discussion
Subject: How to mask the numbers with "*" field


Dear Guys,

I have an employee table where salary is the number field.
Now i want to mask all the numbers in the salary field with "*"
character. i.e

Ram 555 ***
Viji 1234 ****

Thanks & regards,
Gururaj.c.m.

!-- Virus-Free Mail Using PostMaster Enterprise AvAc & QuickHeal Engine
--!

----------------------------------------------------------------
Bluechip Computer Consultants Pvt Ltd, Bangalore, India
Sent using PostMaster by QuantumLink Communications Pvt Ltd
One Internet account, unlimited personal e-mail addresses
Get your free copy of PostMaster at http://www.postmaster.co.in/


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page