Re: Sqlldr to remove 1st line of data file

From: Ron Rogers <RROGERS_at_galottery.org>
Date: Fri, 12 Mar 2004 13:13:41 -0500
Message-Id: <s051b79b.078@galottery.org>

I think skip 1 works.
Ron

>>> david.m.nguyen_at_xo.com 03/12/2004 1:05:57 PM >>>
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

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Fri Mar 12 2004 - 12:10:45 CST