SQL*Loader POSITION clause question
Date: Tue, 12 Jul 1994 19:37:09 GMT
Message-ID: <CsuEHx.385_at_wtc35a.DaytonOH.NCR.COM>
I have a simple question about SQL*Loader. We are in the process of converting
to Oracle and I'm working on interfaces to our legacy systems. What I'm
wondering is can I concatenate data from two or more positions within my INFILE
record and load them into a single column? Example:
My INFILE record looks like this:
XX1234-56-78XXXX
INTO TABLE mytable
where mycolumn2 is made up of more than one POSITION clause. I'm trying to sift
through the Utilities User's Manual but I can't seem to find an example
describing this type of manipulation. Thanks in advance!
Tim Wendt
(
..
mycolumn1 POSITION ....,
mycolumn2 POSITION (3:6) + POSITION (8:9) + POSITION (11:12),
mycolumn3 POSITION
)
AT&T Global Information Solutions
"Mmm...beer" - Homer (Simpson)
Received on Tue Jul 12 1994 - 21:37:09 CEST