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
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...Received on Mon Aug 07 2000 - 00:00:00 CEST
> 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