Just curious : why do you want to know in advance the value of an hash_value? -----Original Message----- From: Adi Hirschtein [mailto:adi@xxxxxxxxxxxxx] Sent: Thursday, 21 September, 2006 4:51 PM Hi guys, I checked it and it's great !!! Thanks a lot. Most appreciated, Adi -----Original Message----- From: Nigel Thomas [mailto:nigel@xxxxxxxxxxxxxx] Sent: 21 September 2006 14:09 > I'm trying to calculate the hash value of statements as oracle does in > the v$sqlarea. How about parsing the query and letting Oracle do the work for you? -- //www.freelists.org/webpage/oracle-l