Xref: alice comp.databases.oracle.tools:22988
Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!howland.erols.net!portc02.blue.aol.com!audrey01.news.aol.com!not-for-mail
From: danhw@aol.com (DanHW)
Newsgroups: comp.databases.oracle.tools
Subject: Re: help: sqlldr control file
Lines: 24
X-Admin: news@aol.com
Date: 4 Apr 1999 16:02:00 GMT
Organization: AOL http://www.aol.com
References: <7dr865$qs$1@nnrp1.dejanews.com>
Message-ID: <19990404120200.01615.00002434@ng114.aol.com>

>Hi there, I have a outside source data file that contains 3 column seperated
>by tab.  However, the data of the 3rd column itself has embedded tabs: A0001 
>     B0001   C0001   a1      a2      a3
>
>'A0001' is 1st column, 'B0001' is 2nd column, 'C0001	a1	a2	a3'
>is the 3rd column that has embedded tabs(number of tabs are different in
>different records).  How can I define in the control file to load this using
>sqlldr?
>
>Thanks in advance!
>
>Ed
>

In the .CTL file, you can specify how each field is terminated separately. You
can also use relative positioning to specify the fields.

Look in the SQLLOADER documentation for more details.

Hope that helps a little

Dan Hekimian-Williams