displaying to_char formatting in Perl

From: Nancy McMullin (NANCY.MCMULLIN_at_DFAS.MIL)
Date: 05/27/04 

Date: Thu, 27 May 2004 13:27:40 -0600
To: <beginners@perl.org>

When attempting to display a formatted string in Perl using Oracle -

SELECT
   TO_CHAR(dollar_amt, '$999,999.99')
   FROM
   table;

It breaks the code. It does work as a straight SQL query outside of Perl. Any ideas?

Thanks.

Relevant Pages

  • Re: displaying to_char formatting in Perl
    ... > When attempting to display a formatted string in Perl using Oracle - ...
    (perl.beginners)
  • Re: ANNOUNCE: DBD:Oracle 1.18
    ... Well a warning in one compiler is better than and error in an other so I ... This might be a problem more with the older oracle OCI in your client. ... perl -Mblib t/26exe_array.t ...
    (perl.dbi.users)
  • Re: float bug? perl 5.8, DBI and oracle 10.2.0
    ... If you want to store high precision numbers in oracle, you've got 38 decimal digits to play with, and with minimal coaxing perl will handle them as strings at the appropriate points so that the exact values go in and come out. ... I haven't done any numerical work in 10 years or so, but I seem to recall that one can reasonably expect 6 or so decimal significant digits from a 32 bit floating point number - I'll go out on a limb and hazard that one can expect 12 or so digits from a 64 bit floating point number - at any rate I'd be very surprised to get 18 significant digits. ...
    (perl.dbi.users)
  • Re: Is perl better? :(((
    ... >> Wasthe original PERL script hitting an Oracle database? ... >> Did you run an explain plan on your Oracle SQL? ... Java and perl on another. ...
    (comp.lang.java.databases)
  • Re: Is perl better? :(((
    ... >> Wasthe original PERL script hitting an Oracle database? ... >> Did you run an explain plan on your Oracle SQL? ... Java and perl on another. ...
    (comp.lang.java.programmer)