in reply to Field name appearing in caps which falis other query(Perl with Oracle)

Set the DBI attribute 'FetchHashKeyName' to 'NAME_lc' for getting the field name in lower case. For eg:
#For getting the lower case $dbh->{FetchHashKeyName} = 'NAME_lc';

#For getting the upper case $dbh->{FetchHashKeyName} = 'NAME_uc';
For more information, please go through FetchHashKeyName