If your database column is numeric, Loader will put the
records with non-numeric field into .bad file - it is
a sort of filtering.
If the column is char by some deep reasons, it's worth to
make a check constraint for it.
--
Alexander I.Doroshko, aid_at_grant.kharkov.ua
- Bank "Grant", Kharkov, Ukraine
hazledid <david.hazledine_at_roche.com> wrote in article
<qveY2.4711$vY2.18322_at_c01read01.service.talkway.com>...
: One of the fields in a data file contains numeric values, but an
: occasional record has an alphanumeric in the field.
: I wanted to filter out these alphanumerics when loading the file with
: SQL*Loader, and I thought I could use the WHEN clause as follows:
:
: WHEN TRANSLATE(field,'$0123456789','$') IS NULL
:
: However, it turns out that SQL functions can't be used in WHEN
clauses.
: Cany anyone suggest a means of performing this
: filtering with SQL*Loader?
:
: David J. Hazledine
: Roche Products Limited
: 40 Broadwater Road
: Welwyn Garden City
: AL7 3AY
: United Kingdom
: Registration Number 100674
: Tel. +44 (0)1707 366166
Received on Thu May 06 1999 - 09:40:15 CDT