Re: How can I use an encryption on a column of certain table?

In article <9ifnkk$gn6$1_at_bob.news.rcn.net>, "Jong says...
>
>Hi
>
>Is there anyway I can encrypt one column of table?
>Something like that:
>
>Table Customers
>
>Cust_name Credit_card_num
>Tom &*@(!#)!$&*@($
>Jane $@&*()!$)#@!&$
>
>If there is way can be done, please let me know how and what has to be done
>on application level to use it.
>
>Thank you very much.
>
>Jong
>
>
>

Sigh, not a version to be seen anywhere. Ok, assuming Oracle8i release 2, see

http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:685421699413

it shows how to use the dbms_obfuscation_toolkit to do that. prior to 8i release 2, you need to encrypt the data before putting it in the database (in the client) as there is no native encryption.

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp