Re: Using SQL*Loader
From: Gene Gurevich <geneg_at_umich.edu>
Date: 1996/06/19
Message-ID: <Pine.SOL.3.91.960619084148.7738C-100000_at_gorf.rs.itd.umich.edu>#1/1
> : If positions (1:6) = "SLSMNO" I want to insert those records
> : into say table # 1. The catch is I want to insert 2 fields one
> : with the code 1 and the other with the description. I don't want to
> : actually insert SLSMNO in any field -- as is the example in the oracle
> : manual.
Date: 1996/06/19
Message-ID: <Pine.SOL.3.91.960619084148.7738C-100000_at_gorf.rs.itd.umich.edu>#1/1
> Carol Kilner (kilnerc_at_basf-corp.com) wrote:
> : If positions (1:6) = "SLSMNO" I want to insert those records
> : into say table # 1. The catch is I want to insert 2 fields one
> : with the code 1 and the other with the description. I don't want to
> : actually insert SLSMNO in any field -- as is the example in the oracle
> : manual.
> : Similary, if positions (1:5) = "TERR"
What you might do is as follows:
Insert into TABLE1
when ( (1:6) = 'SLSMNO')
(FIELD_NAME1 ..position (6:??),
FILED_NAME2 ...)
Insert into TABLE2
when ( (1:4) = 'TERR')
etc
Hope it helps Received on Wed Jun 19 1996 - 00:00:00 CEST