for my $r (@values) { for my $k (keys %$r) { print "$k: $r->{$k}\n"; } } #### my $sth = $db->prepare($sql) or die $db->errstr; $sth->execute or die $db->errstr; while( my $h = $sth->fetchrow_hashref ) { for my $k (keys %$h) { # also see each() print "$k: $h->{$k}\n"; } }