<div>
<div class="content wysiwyg-content">
Hi ,<br />
<br />
I am using sqlloader to load the below file to the table.<br />
<br />
The file content is : 1.txt<br />
<br />
Started<br />
FirstName,LastName<br />
Craig,G<br />
Simon,R<br />
Finished<br />
<br />
I want to skip the header and trailer, for header i can use OPTIONS SKIP line 1 but dont know how to skip <br />
line1,2, and lastline in the file.<br />
<br />
My AIM is to load only lines separated by comma.<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />
Thanks
</div>
</div>


Hi ,

I am using sqlloader to load the below file to the table.

The file content is : 1.txt

Started
FirstName,LastName
Craig,G
Simon,R
Finished

I want to skip the header and trailer, for header i can use OPTIONS SKIP line 1 but dont know how to skip 
line1,2, and lastline in the file.

My AIM is to load only lines separated by comma.
	
Thanks

Oracle loader help

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.