my $hashref=$dbh->getall_hashref("select * from abc where col=?",$val);
my $arrayref=$dbh->getrow_arrayref("select * from abc where col=?",$val);
etc...