Re: How do I change the interpreted decimal character in an external table file

On 29 Aug 2005 12:51:14 -0700, "Doug" <dougburns_at_yahoo.com> wrote:

>Jaap,
>
>You need to look at the ACCESS PARAMETERS clause on the external table
>itself, where the delimiters etc. are defined. It's all in the online
>documentation for external tables.
>
>Cheers,
>
>Doug

Doug, I'm not looking for the handling of delimiter characters BETWEEN fields, but the handling of a comma as a decimal point WITHIN a field. So if a fields contains

12,345

I want Oracle to interpret this as 12 units and 345thousandths of a unit, and NOT twelve thousand three hundred and fourtyfive or error on this value.

This is doable in SQL*Loader, because you can set environment parameters for the OS-session in which you run SQL*Loader to achieve this, but how do you do it when you for instance select from an external table in a procedure?

Jaap. Received on Tue Aug 30 2005 - 12:48:12 CDT