You can use some sql operators on each individual field but not to filter
rows to my knowledge.
M
hazledid wrote in message ...
>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
>
>--
>Posted via Talkway - http://www.talkway.com
>Exchange ideas on practically anything (tm).
>
Received on Thu May 06 1999 - 07:22:29 CDT
