I believe you're looking for the fetchall_arrayref method. You can use it like this:

my $rows = $sth->fetchall_arrayref;
print "$_->{'name'} $_->{'age'}, $_->{'height'}" for (@$rows);
[download]

If the number of returned rows is huge however, you may want to fetch them one at a time, using fetchrow_hashref:

while (my $row = $sth->fetchrow_hashref) {
    print "$row->{'name'} $row->{'age'}, $row->{'height'};
}
[download]

Update: confused fetchall_hashref with fetchall_arrayref...