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: import number

Re: import number

From: Ralph Graulich <ralph_at_grauli.ch>
Date: Wed, 06 Mar 2002 15:51:16 +0100
Message-ID: <ralph-C1E19D.15511606032002@doorway.ih.reiff.de>


Hi Andreas,

> Hi ! I have a problem with the import from a textfile. I want to
> import a number +123.45. That doesnt work. But 123,45 works . Who can
> help ?

You can use "awk" on the UNIX side to cut of the leading sign or you can carefully read the SQL*Loader manual on how to accomplish this with the oracle tool.

Regards
... Ralph ... Received on Wed Mar 06 2002 - 08:51:16 CST

Original text of this message

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