Question:

Is there a way using oracle built-in function to encrypt plain text?
Actually my problems is that I store all the authentication information
(including password)
inside a LOGIN_TABLE. My ideal plan is to encrypt the password. So can it be
doen within ORACLE?
If yes, how to? and how to decrypt also?

For example, when we go to select password from all_users,
we should be able to see lots of encrypted passwords. In fact that is what I
desire.

Hope that you all can help me in solving this headache.
Your help would be greatly appreciated.

Answer 1:

See http://osi.oracle.com/~tkyte/Misc/Passwords.html for some info on
this subject

Answer 2;

There is a package called the DBMS_OBFUSCATION_TOOLKIT that does data
encryption. It is (or will be) available in Oracle8i 8.1.6.