You can always change number column to varchar and then you can insert what
ever you want





"Gururaj "
<oracledba-ezmlmshield-x28507466.[Email Address Removed] To: "LazyDBA Discussion" <[Email address protected]
azyDBA.com> cc:
Subject: How
to mask the numbers with "*" field


10/07/04 12:51 PM





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