Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Is there a way to use "COLUMN FORMAT" in a Pro*C/C++ app?
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