Oracle SQL SELECT using SHA-1 HASH function

[Beagle]

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

[gym dot scuba dot kennedy at gmail]

"Beagle" <beag...@hotmail.com> wrote in message
news:ec0efd4b-50b6-4e4b...@v16g2000prc.googlegroups.com...

http://www.psoug.org/reference/dbms_crypto.html
Jim