I want to encrypt the 'password' and store it in the database and decrypt it on a 'later' date.
I am using the dbms_obfuscation_toolkit package as suggested by oracle.
Problem is, when I use the dbms_obfuccation package, the data will be converted to raw and then encrypted and stored again in the raw variable. For the display purpose we convert the raw variable using - rawtohex .
Now, I want to just encrypt the data and store in the table.
1) what should be the column type for storing this encryted password .
2)Can I store the encrypted data in the varchar2 datatype column and if so how do I decrypt this data later.