Oracle SQL SELECT using SHA-1 HASH function

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 Received on Sat Nov 08 2008 - 11:09:32 CST