Tags: below, clause, comma, database, delimited, example, fields, files, mysql, oracle, spec, sql, sqlldr, tab, terminated
SQLLDR - spec for "fields terminated" clause for tab delimited files
Does anyone know what the spec for tab delimited files is for the "fields terminated" clause in SQLLDR? See the below example for a comma delimited file:
FIELDS TERMINATED BY ","
Thanks in advance!
Leave a comment...
- 2 Comments
- Hi Jeff,
You can try this,
TERMINATED BY WHITESPACE
The WHITESPACE option is usefull when, delimiter is any whitespace character including spaces, tabs, blanks, line feeds, form feeds, or carriage returns. (Only used with TERMINATED, not with ENCLOSED.)
I hope this will help you.
Thazul.#1; Thu, 21 Feb 2008 21:40:00 GMT
- Thanks Thazul it worked very well.#2; Thu, 21 Feb 2008 21:41:00 GMT