Re: number format

From: Michel Cadot <micadot_at_netcourrier.com>
Date: 2000/08/07
Message-ID: <8mltl8$415$1_at_s1.read.news.oleane.net>#1/1


You can do something like that:

v734> alter session set NLS_NUMERIC_CHARACTERS =',.';

Session altered.

v734> var myNum number;
v734> exec :mynum := 1.198;

PL/SQL procedure successfully completed.

v734> select to_char(round(:mynum,2),'999990D00') from dual;

TO_CHAR(RO


      1,20

1 row selected.

v734> exec :mynum := 1;

PL/SQL procedure successfully completed.

v734> select to_char(round(:mynum,2),'999990D00') from dual;

TO_CHAR(RO


      1,00

1 row selected.

--
Have a nice day
Michel


Sandy <daleelaNOdaSPAM_at_usa.net.invalid> a écrit dans le message :
05073e58.5d657199_at_usw-ex0109-068.remarq.com...

> hi,
>
> is there a way to check if a number entered has just 2
> digits after the comma and to put a comma and to 00 if an
> integer is entered.
>
> thanks
>
> sandy
>
>
> * Sent from AltaVista http://www.altavista.com Where you can also find related Web Pages, Images,
Audios, Videos, News, and Shopping. Smart is Beautiful
Received on Mon Aug 07 2000 - 00:00:00 CEST

Original text of this message