Re: How to print floating point data with commas and $ ?

From: <gareth_at_jamms.org>
Date: Mon, 30 Mar 2009 04:54:18 -0700 (PDT)
Message-ID: <0afe67de-e51d-4836-9ec4-b2bb41a5b1ae_at_j8g2000yql.googlegroups.com>



On 30 Mar, 11:23, pereges <Brol..._at_gmail.com> wrote:
> I've a column of salaries in a table and I want them to print in the
> format $999,990.00. How to go about doing this ?

SQL> COLUMN salary FORM $999,999,999.00

http://download.oracle.com/docs/cd/B19306_01/server.102/b14356/toc.htm#i765269

HTH -g Received on Mon Mar 30 2009 - 06:54:18 CDT

Original text of this message