Re: number formatting function in PL/SQL

From: John Darrah <john.darrah_at_usa.net>
Date: 20 Jul 2001 10:43:04 -0700
Message-ID: <4af5a619.0107200943.5530dcd9@posting.google.com>

john.darrah_at_usa.net (John Darrah) wrote in message news:<4af5a619.0107190946.6d6c22f9_at_posting.google.com>...
> Does anyone have or know of a function the will place ","s in the
> correct place on a number? This would be identical to the for
> 999,999,999 feature in sql*plus but used inside pl/sql
>
> thanks

Never mind, I'm a moron. TO_CHAR(<number>,'999,999,999') works quite well. Received on Fri Jul 20 2001 - 12:43:04 CDT