Re: question!
Date: Tue, 28 Mar 2000 09:08:30 +1000
Message-ID: <8boq3c$jqs$1_at_perki.connect.com.au>
1* select '$'||to_char(123556.77,'000,000.00') from dual SQL> / '$'||TO_CHAR
$ 123,556.77
Tom
Chrystian Barragan <chrystianb_at_yahoo.com> wrote in message
news:8boe35$n5r$1_at_nnrp1.deja.com...
> Hi everybody!
>
> I have a problem, and I hope any of you could help me.
>
> I'm working with OAS 4.0.8.1 on NT, I'm developing some "test
> applications" using the PL/SQL cartridge and in one of them I'm using
> the function: owa_util.cellsprint(), which generates a table in HTML
> format with the result of a query, well, what I want to do is to format
> a column which contains a quatity of money, I mean, if you have this:
> 23456.6, I want it to be printed this way: $ 23, 2456.60, but I don't
> know how to specify the format. In this procedure there is an attributte
> which is for format number, but I don't know what values are allowed...
>
> Thanks in advance for any help!!
> --
> *************************
> Chrystian Barragan
> Systems Developer
> Luthe Group, Guadalajara MEXICO
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Mar 28 2000 - 01:08:30 CEST