Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: number format

Re: number format

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Wed, 3 Nov 1999 11:31:53 +0100
Message-ID: <941625157.3231.0.pluto.d4ee154e@news.demon.nl>


Assuming you did not make sure the database is running in German, the english conventions apply, so 123.45
However, if you set NLS_NUMERIC_CHARACTERS = ',.' (as env var or as registry key) you can change that, if that's the issue.

Hth,

--
Sybrand Bakker, Oracle DBA
Andreas Lommel <him_lommel_at_t-online.de> wrote in message news:3820010f.3058277_at_news.btx.dtag.de...
> Hi, I try to load data into a table. How can I define the number
> format? (123.45 or 123,45)
>
>
Received on Wed Nov 03 1999 - 04:31:53 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US