Home » RDBMS Server » Server Utilities » IN SQL LOADER Is it possible to skip fields
IN SQL LOADER Is it possible to skip fields [message #69119] Fri, 02 November 2001 09:01 Go to next message
Joy
Messages: 21
Registered: November 2001
Junior Member
Hi,
I would like to know if there is any way that i skip some fields in the datafile when i use SQL LOADER.The data i have is tab delimited and not fixed length.
Say there are 10 fields in the datafile and my table has only 6 of them .

----------------------------------------------------------------------
Re: IN SQL LOADER Is it possible to skip fields [message #69124 is a reply to message #69119] Sat, 03 November 2001 09:17 Go to previous messageGo to next message
Ifigenia
Messages: 6
Registered: November 2001
Junior Member
Can you send me a part of your data file?

----------------------------------------------------------------------
Re: IN SQL LOADER Is it possible to skip fields [message #69991 is a reply to message #69119] Wed, 27 March 2002 08:46 Go to previous message
Andrew
Messages: 144
Registered: March 1999
Senior Member
http://www.orafaq.net/faqloadr.htm#SKIPCOL
Previous Topic: Re: FREE OCP PAPERS
Next Topic: application fail
Goto Forum:
  


Current Time: Thu Mar 28 17:35:49 CDT 2024