Re: DECIMAL?

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 16 Dec 2002 13:35:05 -0800
Message-ID: <2687bb95.0212161335.6c46d83e@posting.google.com>

Marc Zinzen <mzinzen_at_genese.de> wrote in message news:<3DFD9049.3C74044C_at_genese.de>...
> Hi
>
> This small problem I can't seem to solve!
> I need Oracle9.2 to accept Decimals with ',' as a delimiter.
> Where or how can I change that. I just can't find the setting.
>
> Marc

Marc, look in v$nls_parameters

NLS_NUMERIC_CHARACTERS
.,

UT1> alter session set nls_numeric_characters = ',.';

Session altered.

UT1> select unit_cost
  2 from cost_item
  3 where rownum < 10
  4 /

 UNIT_COST

---

 889,10172
  65,07938
 174,32904
 716,27325
       200
      2,56

  393,9591
   8,28297
   1,26831

9 rows selected.

The comma is now the decimal point which is normally a '.' around here

HTH -- Mark D Powell -- Received on Mon Dec 16 2002 - 15:35:05 CST