Re: Ignoring records in a control file
From: sybrandb <sybrandb_at_gmail.com>
Date: 7 Dec 2006 08:03:22 -0800
Message-ID: <1165507402.730708.68190_at_j44g2000cwa.googlegroups.com>
Date: 7 Dec 2006 08:03:22 -0800
Message-ID: <1165507402.730708.68190_at_j44g2000cwa.googlegroups.com>
On Dec 7, 4:54 pm, "matthew.d.willi..._at_gmail.com"
<matthew.d.willi..._at_gmail.com> wrote:
> I have a simple control file to import some data. There is a single
> field that I would like to look at the first 2 characters and if they
> meet a certain criteria (begin with ss, zz, tt) then skip that entire
> record and move on to the next.
>
> Suggestions or tips?
>
> Thanks.
Oracle Utilities Manual, WHEN clause in the sqlloader chapters.
-- Sybrand Bakker Senior Oracle DBAReceived on Thu Dec 07 2006 - 17:03:22 CET