use DBI; . . . my $res = $sth->fetchall_arrayref(); # Returns array ref with all result rows which are array refs too. for my $row (@$res) { for my $value (@$row) { print "$value " } print "\n"; }