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

Using NULLIF in SQL*Loader

From: John-Paul <meadj01_at_popmail.med.nyu.edu>
Date: 1997/09/17
Message-ID: <B045B2E5-63812F@128.122.205.107>#1/1

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? Received on Wed Sep 17 1997 - 00:00:00 CDT

Original text of this message

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