Results 1 to 2 of 2

Thread: Continueif

  1. #1
    Join Date
    May 2009
    Posts
    1

    Unanswered: Continueif

    Hi all,

    I am trying to get the following scenario in SQL Loader working.

    rec1 AABBCC
    .
    . XXKKMM
    .
    recn AAFFGG

    I want to load rec1 and recn into one physical record. How can I accomplish this, if the first two characters of rec1 and recn DO NOT equal XX? (the inbetween records always start with the same chars, but the header and footer have different chars) I am using POSITION() for both lines to get the fields I want.

    I hope that makes sense.

    Thanks!

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    I don't think you can convince SQLLDR to do what you desire.

    One alternative would be to use EXTERNAL TABLE & then write custom PL/SQL to do what needs to be done.
    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.

Posting Permissions

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