while ( my $row = $sth->fetchrown_hashref ){ $hasho{ $row{org_id} } = $row{org_nm}; } #### while ( my ( $org_id, $org_nm ) = $sth->fetchrow_array()) { $hasho{$org_id} = $org_nm; } #### my %hash = map { $_->{org_id} => $_->{org_nm} } @{ $sth->fetchall_arrayref }; #### split//,q{john hurl, pest caretaker}and(map{print @_[$_]}(join(q{},map{sprintf(qq{%010u},$_)}(2**2*307*4993,5*101*641*5261,7*59*79*36997,13*17*71*45131,3**2*67*89*167*181))=~/\d{2}/g));