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

On Database » Oracle

592 words with 2 Comments; publish: Fri, 08 Feb 2008 17:46:00 GMT; (25062.50, « »)

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!

Jeff

All Comments

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.

      Thanks,

      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