Using NULLIF in SQL*Loader
From: John-Paul <meadj01_at_popmail.med.nyu.edu>
Date: 1997/09/17
Message-ID: <B045B2E5-63812F_at_128.122.205.107>#1/1
Date: 1997/09/17
Message-ID: <B045B2E5-63812F_at_128.122.205.107>#1/1
[Quoted] [Quoted] I am trying to load an Oracle7 database with data from a text file.
[Quoted] [Quoted] 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).
[Quoted] [Quoted] 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 CEST