Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2002
    Posts
    2

    Unanswered: loading a tab separated text file

    How do you load a tab-separated text file using SQL*Loader in Oracle 8iR3?

  2. #2
    Join Date
    May 2002
    Location
    Phoenix, AZ
    Posts
    24
    This is a simple example that uses inline data. Note that 09 is the hexadecimal value for a tab character:

    LOAD DATA
    INFILE *
    INTO TABLE DEPT
    REPLACE
    FIELDS TERMINATED BY X'09'
    (
    DEPTNO,
    DNAME,
    LOC
    )
    BEGINDATA
    10 Sales Virginia

Posting Permissions

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