I assume you're talking about DBI. Once you have an executed $sth, you can use $hash_ref = $sth->fetchrow_hashref. Then $hash_ref is a hash reference with the Database's columns as keys and the values for the fetched row as values. $hash_ref will be undef after you've fetched the last row, so it's useful in a while loop.

while ( $hash_ref = $sth->fetchrow_hashref )
{
   $value_1 = $hash_ref->{"COLUMN_1"};
   $value_2 = $hash_ref->{"COLUMN_2"};

   # Do something with values
}
[download]

I've only used DBI with Oracle, but I know that with Oracle, the column names are always in uppercase when using fetchrow_hashref. Hope that's what you were looking for...