Suprise? Hash value can be easly calculated knowing sql_id:
select
lower(trim('&1')) sql_id
, trunc(mod(sum((instr('0123456789abcdfghjkmnpqrstuvwxyz',substr(lower(trim('&1')),level,1))-1)
*power(32,length(trim('&1'))-level)),power(2,32))) hash_value
from
dual
connect by
level <= length(trim('&1'))
/
Tuesday, August 04, 2009
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment