Sqlldr to remove 1st line of data file
- From: "Nguyen, David M" <david.m.nguyen@xxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 12 Mar 2004 13:05:57 -0500
I want to load data file into oracle database and I need to remove the
first line inside of data file before loading. How do I tell sqlldr to
remove the first line of data file?
**My data file in csv format:
# Northeast,1,GABE0,66.89.254.25 <=== Need to remove this line before
loading data.
2/27/04 10:44:52 PM CST,13,13,0,43,0,446,0
2/27/04 10:59:52 PM CST,3,3,0,15,0,446,0
2/27/04 11:14:52 PM CST,7,7,0,23,0,446,0
2/27/04 11:29:52 PM CST,7,6,1,18,0,446,0
Thanks,
David
Other related posts:
