Search notes:

Oracle: DBMS_UTILITY.SQLID_TO_SQLHASH

dbms_utility.sqlid_to_sqlhash converts an SQLID to the corresponding hash value.

In the following query, in each record, the first value is equal to the second value:

select
   dbms_utility.sqlid_to_sqlhash(sql_id),
   hash_value
from
   v$sql
;

See also