原来sql_id可以转化成hash value

 看了Tanel Poder的blog: http://blog.tanelpoder.com/2009/02/22/sql_id-is-just-a-fancy-representation-of-hash-value/

select trunc(mod(sum((instr('0123456789abcdfghjkmnpqrstuvwxyz',
                            substr(lower(trim('&1')), level, 1)) - 1) *
                     power(32, length(trim('&1')) - level)),
                 power(2, 32))) hash_value,
       lower(trim('&1')) sql_id
  from dual
connect by level <= length(trim('&1'));

&1：175374387

HASH_VALUE SQL_ID
---------- --------
3925696503 175374387