Re: Commas and decimal places to signify decimal point
- From: "Terry Dykstra" <tddykstra@xxxxxxxxxxxx>
- Date: Thu, 17 Nov 2005 18:04:51 GMT
You want to issue a "alter session set nls_numeric_characters = 'xxxxx' "
before you start loading data (set xxxx to desired format).
--
Terry Dykstra
Canadian Forest Oil Ltd.
"Peter Nolan" <peter@xxxxxxxxxxxxxx> wrote in message
news:1132248476.884219.226590@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> Hi All,
> I came across an unusual problem today....
>
> We are just getting started loading incoming files into a staging area
> to analyse source data for a DW build.
>
> I am sending data into a database (that I didn't set up and am not the
> dba for) using ODBC calls where the ODBC call sends a character string
> representation of the value to the oracle driver and oracle performs
> the implicit data conversion....
>
> I didn't notice it...but yesterday I loaded some data where the number
> format was nnn,nn . Today we got some data from a different country in
> the format nnn.nn . And this gets invalid number format.
>
> It looks like the database is set up to have just ',' recognised as the
> decimal point.
>
> Is there any way to recognise both ',' and '.' as a decimal point or
> must I ensure that these things are consistently just one value for the
> target database?
>
> (Yes, I have always just used '.' for the decimal point)
>
> Thanks
> Peter
> www.peternolan.com
>
.
- References:
- Commas and decimal places to signify decimal point
- From: Peter Nolan
- Commas and decimal places to signify decimal point
- Prev by Date: Re: Index Compression
- Next by Date: Getting Oracle TDE Wallet State
- Previous by thread: Commas and decimal places to signify decimal point
- Next by thread: Getting Oracle TDE Wallet State
- Index(es):
Relevant Pages
|
