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

Home -> Community -> Usenet -> c.d.o.server -> How do I change the interpreted decimal character in an external table file

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

From: Jaap W. van Dijk <j.w.vandijk.removethis_at_hetnet.nl>
Date: Mon, 29 Aug 2005 21:36:39 +0200
Message-ID: <o4o6h1dvmj2hmj3fq4e72oljenvrgh6qgk@4ax.com> 





Hi,



Oracle 9.2.0.6 on Windows or Unix:



When I read a file by means of a external table, the fullstop is
interpreted as the decimal character. How do I change that to a comma,
for this external table file only? 


I tried performing an ALTER SESSION of NLS_TERRITORY or
NLS_DECIMAL_CHARACTERS, but this doesn't change the interpretation, it
only changes the displayed character in the SELECT-output from a
fullstop to a comma.



Jaap.
Received on Mon Aug 29 2005 - 14:36:39 CDT












Original text of this message













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