Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003
    Posts
    2

    Unanswered: Sql Loader problem

    I have a '|' delimited free format file , the records as shown below

    1234|Hello world|1234.12|123.12
    1234|HI|124.12|13.12
    1234|XXXXX|234.12|12.12

    I have table X ( col1 number(4),col2Number(10,2)) and another table
    Y (col1varchar(200),col2 Number(10,2))

    Now my requirement is to load the data into table X and Y using Sql Loader so that the first and third columns of the data file is loaded into table X and the second and fourth column is loaded into table Y .

    Any idea how to do that ?

    Thanks in advance

  2. #2
    Join Date
    Jul 2003
    Posts
    2,296
    look up documentation.
    specifically regarding FILLER

    PHP Code:
    into table X
    fields terminated by 
    '|'
    (
    col1 number,
    dummy1 FILLER,
    col2  number

    - The_Duck
    you can lead someone to something but they will never learn anything ...

  3. #3
    Join Date
    Dec 2003
    Posts
    2
    Thanks it workd fine for me ..

Posting Permissions

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