sqlload question
From: Larry Claman <claman_at_copley.csc.mckinsey.com>
Date: Wed, 31 Mar 1993 00:50:59 GMT
Message-ID: <C4qAD0.B2x_at_copley.csc.mckinsey.com>
Date: Wed, 31 Mar 1993 00:50:59 GMT
Message-ID: <C4qAD0.B2x_at_copley.csc.mckinsey.com>
Hello. Can anyone help me me with the following sqlload problem: I have file that is comma delimited. I only want to load (for example) fields 1 and 3 into my oracle table. Is there an sqlload .ctl syntax that will let me skip field 2? Or am I stuck "awking" the file?
For example, suppose my file is:
name, city, state
and my oracle table is:
name_column char(10), state_column char(2)
How do create a .ctl file to load name and state into name_column and state_column, without loading city?
Thanks for your help!
-Larry Claman
claman_at_copley.csc.mckinsey.com
Received on Wed Mar 31 1993 - 02:50:59 CEST