Sql*loader Problem
From: <brettschneider_at_my-deja.com>
Date: Fri, 03 Sep 1999 15:14:56 GMT
Message-ID: <7qool3$hcf$1_at_nnrp1.deja.com>
I have a problem that I haven't seen addressed in the sql*loader manual. I will be loading in a bunch of records from an Ascii file. The header record contains a field that has to be loaded with all the other records as a constant. Is there anyway to pick up that field and load it with the rest of the records.
Date: Fri, 03 Sep 1999 15:14:56 GMT
Message-ID: <7qool3$hcf$1_at_nnrp1.deja.com>
I have a problem that I haven't seen addressed in the sql*loader manual. I will be loading in a bunch of records from an Ascii file. The header record contains a field that has to be loaded with all the other records as a constant. Is there anyway to pick up that field and load it with the rest of the records.
e.g.
chicken,dog,cat aa,1234,3333 bb,4321,4444 cc,7645,1111
Table should look like:
dog,aa,1234,3333 dog,bb,4321,4444 dog,cc,7645,1111
Thanks for any help.
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.
Received on Fri Sep 03 1999 - 17:14:56 CEST