8 Replies Latest reply: Sep 30, 2011 1:52 PM by Syed Ullah RSS

    skipping last line in file using sql loader

      Hi all, i would like to know how to skip the last line in a file using sql loader. i have a file such as:
      2345665    Tech INC   MECA    45CA
      572ACTS    ERD LLC   SUE       CCCC
      The last line in file is a number. i was trying to use when clause but no use. if you look at the data above, the first field could also start with numbers. for such a file, how can skip the last line (footer) in the ctl file? thanks