Question: I want to use
sqlldr (the SQL:*Loader) utility to load a tab delimited file. How do
I specify a tab delimiter in SQL Loader control files?
Oracle 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
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'
To see working
examples of sqlldr
control file delimiters, check out the code download in
the new book "Advanced Oracle Utilities", highly recommended to learning SQL*Loader
Get the Complete
Oracle Utility Information
The landmark book
Utilities The Definitive Reference" contains over 600 pages of
filled with valuable information on Oracle's secret utilities.
This book includes scripts and tools to hypercharge Oracle 11g
performance and you can
for 30% off directly from the publisher.