Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> sqlldr missout first line

sqlldr missout first line

From: Dominic Bines <dombaines_at_yahoo.com>
Date: 14 Mar 2002 04:05:23 -0800
Message-ID: <205f56a7.0203140405.4dc6beb5@posting.google.com>


I have a series of files that need to be loaded to rows in a table one per row. The rows will have two columns only the second one is loaded for these files.

They are CLOBs... each averages 200K characters, not all have a 80 column width so I can't just say start at character 80 either.

At the start of every file content there is a series of information that is of no use and should/could be stripped out...

Now I know it might be possible to use perl or something similar to create temporary files and load those... but how would you use sqlldr to ignore the first line of the file instead?

Regards,

Dominic Received on Thu Mar 14 2002 - 06:05:23 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US