Re: Oracle SQL SELECT using SHA-1 HASH function
From: gym dot scuba dot kennedy at gmail <kennedyii_at_verizon.net>
Date: Sat, 08 Nov 2008 17:18:16 GMT
Message-ID: <sRjRk.167$U5.153@nwrddc01.gnilink.net>
Date: Sat, 08 Nov 2008 17:18:16 GMT
Message-ID: <sRjRk.167$U5.153@nwrddc01.gnilink.net>
"Beagle" <beagle197_at_hotmail.com> wrote in message
news:ec0efd4b-50b6-4e4b-a4a7-61af253ba35b_at_v16g2000prc.googlegroups.com...
> Folks,
>
> Is there a way to perform this kind of SQL select command?
>
> SELECT id FROM user WHERE password = SHA1('secret');
>
> I have been searching, but it does not appear this is a built in
> Oracle function. I am looking from some function that works for
> version Oracle 9 and above.
>
> Thank you,
> BEA
http://www.psoug.org/reference/dbms_crypto.html
Jim
Received on Sat Nov 08 2008 - 11:18:16 CST