Using SQL*Loader
From: Carol Kilner <kilnerc_at_basf-corp.com>
Date: 1996/06/17
Message-ID: <31C5EEE7.3311_at_basf-corp.com>#1/1
Date: 1996/06/17
Message-ID: <31C5EEE7.3311_at_basf-corp.com>#1/1
I'm trying to do the following using SQL*Loader. Can it be done.
If have the following input file
SLSMNO1 Salesman Name # 1
SLSMN02 Salesman Name # 2
INDGRP1 Industry Group # 1
INDGRP2 Industry Group # 2
TERR1 Territory desc # 1
TERR2 Territory desc # 2
...you get the idea.
Similary, if positions (1:5) = "TERR"
Thanks,
Carol Kilner
BASF Canada
Received on Mon Jun 17 1996 - 00:00:00 CEST