Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

encrypted password into the table

711216Aug 6 2009 — edited Aug 7 2009
Hi All,

i am developing an application which uses login page.i want to store only the encrypted password into the table rather than the readable form of password(useful for guarding the users account accessing by other people looking into table).is there any oracle's function to do that.I am using oracle 9i.

i have written below statement. its working fine. But is there any other mode like use ina package ..or ?

INSERT INTO login_details
VALUES ('SUMAN',
TRANSLATE (upper('pass'),
'ABCDEFGHIJKLMNOPQRSTUVWXYZ ',
'1234567890!@#$%^&*()-=_+;,.'
))

Regards,
Kiran
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 4 2009
Added on Aug 6 2009
11 comments
2,136 views