Skipping fields using SQL*Loader?
From: George Brown <gbrown_at_partech.com>
Date: 1995/04/27
Message-ID: <gbrown-2704951747560001_at_browng.partech.com>#1/1
Date: 1995/04/27
Message-ID: <gbrown-2704951747560001_at_browng.partech.com>#1/1
Can SQL*Loader skip fields when loading? For example, say I had a file
containing:
1, 2, 3, 4, 5
Assume that the CTL file has a terminated by "," clause. I want to load:
1, 2, 3 into one table and
1, 4, and 5 into another table (using position(1) to reset to the
begining of the line). Is there a way to do this?
-- George Brown Voice: 315-738-0600x250 8383 Seneca Turnpike FAX: 315-738-8304 New Hartford, NY 13413-4991 e-mail: george_at_partech.comReceived on Thu Apr 27 1995 - 00:00:00 CEST