Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Sql*loader Problem
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 - 00:00:00 CDT