Home » RDBMS Server » Server Administration » how can I encrypt password and decrypt by using oracle stored procedure
how can I encrypt password and decrypt by using oracle stored procedure [message #370609] Thu, 06 January 2000 13:01 Go to next message
venkat Veerareddy
Messages: 4
Registered: January 2000
Junior Member
I need to encrypt user id and password and decrypt also by using oracle stored procedure.
Re: how can I encrypt password and decrypt by using oracle stored procedure [message #371416 is a reply to message #370609] Mon, 16 October 2000 11:57 Go to previous message
Prabhakar
Messages: 9
Registered: April 1999
Junior Member
Hi,
I need your help can please send me info about this that is
they want me to write two functions to store credit card number in encrypted manner
so that no one can see the credit card number and retrive the same in decripted manner

The functions are below but I'm not sure how to write the functions I'm syntax so
if you please help me or through your friends that would be fine

(1) Function Encrypt(IN credit card number) returns encrypted credit card number

(2) Function Decript (IN encrypt credit card number) return credit card number

.............................

select Decript(encrypt (x))
From dual;

My email is pallathur@c-bridge.com

Thank you
Previous Topic: Drop Column SET UNUSED Clause
Next Topic: ip address
Goto Forum:
  


Current Time: Fri Mar 29 07:21:08 CDT 2024