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
Printable View
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
I believe so -- look at "SQL*Loader Case Study 5" in the Utilities Guide -- you could adapt the technique used there, i think.