DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: SQL loader & TAB delimited data file

Hybrid View

  1. #1
    Join Date
    Jan 2000
    Location
    HOUSTON, TX
    Posts
    75

    SQL loader & TAB delimited data file

    SQL loader: Do any one know how to put "TAB delimited" reference at control file for TAB delimited data file..

  2. #2
    Join Date
    Nov 2002
    Posts
    170
    I have done it in the past and it sure works...I don't remember the exact syntax.

    Try:
    insert into table xxx
    FIELDS TERMINATED BY ""

  3. #3
    Join Date
    Nov 2002
    Posts
    170
    I have done it in the past and it sure works...I don't remember the exact syntax.

    Try:
    insert into table xxx
    FIELDS TERMINATED BY "(tab)"

    or
    replace
    ( with <
    ) with >

  4. #4
    Join Date
    Jan 2000
    Location
    HOUSTON, TX
    Posts
    75
    OK! Thanks for your reply, but I found it and it will as follows:
    'FIELDS TERMINATED BY WHITESPACE'
    OraMan
    OCP Oracle8, 8i, 9i

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width