Re: Format

From: Frank <fvanbortel_at_netscape.net>
Date: Mon, 17 Mar 2003 21:19:30 +0100
Message-ID: <3E762DD2.2070905@netscape.net>

Sybrand Bakker wrote:
> On Mon, 17 Mar 2003 15:24:13 +0100, "Andrea" <andrea_at_giandrea.com>
> wrote:
>
>

>>Hi
>>
>>how can I show 1.500.000 instead of 1500000
>>
>>thanks
>>Andrea
>>

>
> to_char(<column>, '9G999G999') where G is the group separator as
> defined by your region setting.
>
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address

Sybrand - that was an assignment!

Andrea - get a copy of the SQL statements Quick Reference Guide. They used to come with RDBMS7 documentation, but you can print a copy off the documentation CD. This - and many, many other diamonds are in it.

-- 
Regards, Frank van Bortel

Received on Mon Mar 17 2003 - 14:19:30 CST