Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Is there a way to use "COLUMN FORMAT" in a Pro*C/C++ app?

Is there a way to use "COLUMN FORMAT" in a Pro*C/C++ app?

From: Ramon F Herrera <ramon_at_conexus.net>
Date: 1 Apr 2007 22:50:25 -0700
Message-ID: <1175493025.945294.100170@e65g2000hsc.googlegroups.com>

My application has some SQL statements like this:

SELECT

to_char(amount1, '99,999,990.00'), \
to_char(amount2, '99,999,990.00'), \
to_char(amount3, '99,999,990.00'), \
to_char(amount4, '99,999,990.00'),

[...]

Is that the only way to format real numbers from a precompiler application?

The command "COLUMN FORMAT" seems to work only from SQL*Plus.

TIA, -Ramon F Herrera Received on Mon Apr 02 2007 - 00:50:25 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US