Re: can i use tab as a delimiter in sqlldr?

From: Joel R. Kallman <jkallman_at_us.oracle.com>
Date: Fri, 20 Nov 1998 14:48:31 GMT
Message-ID: <36558079.10824044@newshost.us.oracle.com>

On Fri, 20 Nov 1998 08:51:41 GMT, badstreetboy_at_my-dejanews.com wrote:

>I have some data files ready to load by sql loader. All the fields are
>seperated by tab. How can I specify the tab in control file?
>

In your SQL*Loader control file, you can specify what is the delimiter of the fields in your data. You could specify WHITESPACE, which would let you separate your fields with any whitespace character (space, tab, CR, LF). Or you can specify the terminating character by specifying the hexadecimal value of the character. In the ASCII character set, 9 is the ASCII value of TAB.

As an example:

	LOAD DATA
	INFILE *
	APPEND INTO TABLE foo
	FIELDS TERMINATED BY X'09'
	(id, text)
	BEGINDATA
	1       Joel
	

Check out page 5-65 of the Oracle8 Server Utilities manual where this is covered in detail.

>Thanks.
>
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

Thanks!

Joel

Joel R. Kallman Oracle Government, Education, & Health

Columbus, OH                             http://govt.us.oracle.com

jkallman@us.oracle.com                   http://www.oracle.com

---

The statements and opinions expressed here are my own and do not necessarily represent those of Oracle Corporation. Received on Fri Nov 20 1998 - 08:48:31 CST