Monday, December 10, 2012

SQL Loader with tab delimited File

Oacle SQL*Loader allows you to specify several variations of the tab character in the control files syntax.  There are several ways to load table delimited data into Oracle.

In the control file, you can specify a tab as a backslash t, one way to describe the tab character:

fields terminated by '\t'

Any character can be used as a delimiter and you can specify it's hex representation in the SQL*Loader control file.  The hexadecimal 09 represents the tab character:

fields terminated by x'09'