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?
Answer: 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
'\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'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
syntax.
|
|
 |
|
Get the Complete
Oracle Utility Information
The landmark book
"Advanced Oracle
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
buy it
for 30% off directly from the publisher.
|
|
|
