I like how DBI handles that:

@row_ary    = $sth->fetchrow_array;

$first_val  = $sth->fetchrow_array;

$ary_ref  = $sth->fetchrow_arrayref;
[download]