SQL Loader

[ssmith001]

Can you use multiple WHEN conditions when loading data using SQL Loader?

When INV_TYPE = 'IT'
Load column A
When INV_TYPE = 'IM'
Load column B
When INV_TYPE = 'OH'
Load column C
When INV_TYPE = 'II'
Load column D

[slimdave]

I believe so -- look at "SQL*Loader Case Study 5" in the Utilities Guide -- you could adapt the technique used there, i think.