Oracle SQL SELECT using SHA-1 HASH function

From: Beagle <>
Date: Sat, 8 Nov 2008 09:09:32 -0800 (PST)
Message-ID: <>


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

Original text of this message