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 -> Re: Using NULLIF in SQL*Loader

Re: Using NULLIF in SQL*Loader

From: Frank Hubeny <fhubeny_at_ntsource.com>
Date: 1997/09/17
Message-ID: <34209E9A.66C6@ntsource.com>#1/1

The following would accomplish the purpose

  cls position(*) char "decode(:cls, '0', 0, '1', 1, '2', 2, '3', 3, '4', 4, '5', 5, null)"

John-Paul wrote:
>
> I am trying to load an Oracle7 database with data from a text file.
> One of the columns contains either numerical or character data.
> I would like to ignore the character data, and only load the numerical data
> (between 0 and 5).
> I placed a statement in my SQL*Loader '.ctl' file like this:
>
> cls POSITION(*) INTEGER EXTERNAL NULLIF (cls NOT BETWEEN 0 AND 5),
>
> I get the error:
>
> SQL*Loader-350: Syntax error at line 10.
> Expecting = or "<>", found "NOT".
> cls POSITION(*) INTEGER EXTERNAL NULLIF (cls NOT BETWEEN 0 AND 5),
>
> Does anyone see the problem here?
 

-- 
Frank Hubeny            
fhubeny_at_ntsource.com            
Wheaton, IL 60187
Received on Wed Sep 17 1997 - 00:00:00 CDT

Original text of this message

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