Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2004
    Posts
    205

    Unanswered: import from a flat file ?

    Hi,

    How to load the data from a flat text file having delimiter ',' between columns ?
    Please give a sample query.

    Thanks,
    Sam

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >How to load the data from a flat text file having delimiter ',' between columns ?
    Which school, class, and instructor gave you this assignment?
    Were you paying attention in class when this material was discussed?
    How are you classmates solving this problem?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Mar 2004
    Posts
    205
    Hi,

    Well. This was not discussed in my class. I am a newbie to Oracle.

    If could, please advice.

    Sam

  4. #4
    Join Date
    Mar 2004
    Location
    California
    Posts
    58
    hint: SQL* loader. Research it: http://www.orafaq.com/faqloadr.htm

Posting Permissions

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