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