How to skip first two fields in sql*loader
From: Joe Whalley <jw_at_mitre.org>
Date: Wed, 02 Sep 1998 13:49:58 -0400
Message-ID: <35ED8546.DCD0A5B7_at_mitre.org>
[Quoted] I want to omit two fields in a comma delimited text file. The trouble is, one of those is variable length, so I cant' define the position of the third field with a POSITION value. I can't do relative position, since there is nothing defined before it. Is there some way of defining fields, but not loading them?
thanks
Joe Received on Wed Sep 02 1998 - 19:49:58 CEST
Date: Wed, 02 Sep 1998 13:49:58 -0400
Message-ID: <35ED8546.DCD0A5B7_at_mitre.org>
[Quoted] I want to omit two fields in a comma delimited text file. The trouble is, one of those is variable length, so I cant' define the position of the third field with a POSITION value. I can't do relative position, since there is nothing defined before it. Is there some way of defining fields, but not loading them?
thanks
Joe Received on Wed Sep 02 1998 - 19:49:58 CEST