my $res = $sth->fetchall_arrayref({}); # Returns array ref with result rows which are hash refs. for my $row (@$res) { for my $key (%$row) { print "$$row{$key} " } print "\n"; }