Re: Need help with SQL*Loader - skipping records

Hi Ryan,

    Have a look at the WHEN clause. You can compare to literal values and have multiple comparisons as well.

regards

Jerry Gitomer

no0one1000_at_my-deja.com wrote in message <7k8gfr$ngu$1_at_nnrp1.deja.com>...
>I am using SQL*Loader to load data into Oracle tables. Currently these
>data files are bveing edited manually to strip out header record data
>that doesnt need to be in the data. I know there is a way to skip
>columns but is there any way to do an IF statement and skip an entire
>record?
>
>Thanks
>Ryan
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Wed Jun 16 1999 - 11:44:19 CDT