perlquestion
vroom
When I do a straight up select from a table in Oracle from SQL-Plus I get my number returned in scientific notation.
<CODE>
select large_number from mytable;
LARGE_NUMBER
------------
4.1142E+11
</CODE>
when what I want is something like: 411420431014
Easy enough to fix in theory with TO_CHAR:
<CODE>
select to_char(large_number) from mytable;
LARGE_NUMBER
------------
411420431014
</CODE>
Or somewhat more explicitly with a number format:
<CODE>
select to_char(large_number,'999999999999') from mytable;
LARGE_NUMBER
------------
411420431014
</CODE>
These both return what I want. However when I run the queries with Perl and DBI I get my number back in scientific notation?
<P>
Anyone got a clue on this?