Sql*Loader question with comma-delimited records
From: <rory_at_PROBLEM_WITH_INEWS_DOMAIN_FILE>
Date: 24 Feb 1995 05:49:17 GMT
Message-ID: <3ijs0t$7r4_at_legba.synergy.net>
Date: 24 Feb 1995 05:49:17 GMT
Message-ID: <3ijs0t$7r4_at_legba.synergy.net>
After 5 years with Oracle, I've finally been forced to write some Sql*Loader scripts, and I have a quick and hopefully easy question. I have a comma-delimited file, and I can't get Sql*Loader to skip past the first few. Any ideas? I've managed to use Loader to load variable-length data if: 1) I load ALL the columns (which I don't want to do) 2) I know the offset of the first row I want (I don't because it's variable length records!) Surely there must be some way of saying that this is a variable length record split by commas, and I want to load field 3 and 5? Now I know why I've used perl all these years to parse files and turn them into insert statements:-) Rory Reynoldson rory_at_inetnebr.comReceived on Fri Feb 24 1995 - 06:49:17 CET