vroom has asked for the wisdom of the Perl Monks concerning the following question:
When I do a straight up select from a table in Oracle from SQL-Plus I get my number returned in scientific notation.
when what I want is something like: 411420431014 Easy enough to fix in theory with TO_CHAR:select large_number from mytable; LARGE_NUMBER ------------ 4.1142E+11
Or somewhat more explicitly with a number format:select to_char(large_number) from mytable; LARGE_NUMBER ------------ 411420431014
These both return what I want. However when I run the queries with Perl and DBI I get my number back in scientific notation?select to_char(large_number,'999999999999') from mytable; LARGE_NUMBER ------------ 411420431014
Anyone got a clue on this?
|
---|
Replies are listed 'Best First'. | |
---|---|
Re: Weird problem with Oracle, DBI, and Scientific Notation
by Zaxo (Archbishop) on May 15, 2002 at 00:06 UTC | |
Re: Weird problem with Oracle, DBI, and Scientific Notation
by DigitalKitty (Parson) on May 15, 2002 at 00:02 UTC | |
Re: Weird problem with Oracle, DBI, and Scientific Notation
by theorbtwo (Prior) on May 14, 2002 at 23:00 UTC | |
Re: Weird problem with Oracle, DBI, and Scientific Notation
by rbc (Curate) on May 14, 2002 at 23:08 UTC |
Back to
Seekers of Perl Wisdom