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

Thread: Sqlloader question

  1. #1
    Join Date
    Feb 2000
    Location
    MADRID,ESPAÑA
    Posts
    2

    Question

    How can i load in a varchar2 column, a text that contents returns of line?

    For example the sqlloader file:

    James#My car is red and
    my house is big.#London
    Jason#Hellow my friend!#San Francisco
    Patrick#What a wonderful day!#Philadelphia

    And the table is:

    Name varchar2(20),
    Comment varchar2(250),
    City varchar2(20)



    Thank you.


  2. #2
    Join Date
    Oct 2000
    Posts
    90
    You might have a control file something like this

    LOAD DATA
    INFILE '<filename>'
    INTO TABLE <tablename>
    FIELDS TERMINATED BY ’#’
    OPTIONALLY ENCLOSED BY ’"’
    (name, comment, city)



  3. #3
    Join Date
    Feb 2000
    Location
    MADRID,ESPAÑA
    Posts
    2

    sqlloader reads line to line the text file and when it finds a return of line it rejects the record.

    Thanks.

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