in reply to Check if the first hash value is present in second hashmap

Perl is all well and good, and I love it to bits and all that. But reading your database into a Perl hash when you have an expensive RDBMS sitting there, with all the data loaded, waiting to do such things for you, may not be the best approach. Have a google around Oracle exists or insert and perhaps Oracle update or insert and make some use of the other Larry's code too.

Cheers,
R.

Pereant, qui ante nos nostra dixerunt!