Ron,
try this:
Load data
infile *
Append
Into table tab1
trailing nullcols
( col1 terminated by "," ,
col2 terminated by ",",
col3 terminated by "," ,
col4 terminated by "," ":col3*.07",
col5 terminated by "," )
begindata
123,20010920,20,30,35
123,20010920,20,30,35
123,20010920,20,30,35
I just ran it - works fine!
Tom Mercadante
Oracle Certified Professional
-----Original Message-----
Sent: Friday, September 21, 2001 3:21 PM
To: Multiple recipients of list ORACLE-L
List,
Oracle 7.3.4
Using SqlLoader I load a table with 5 columns of data. I would like to be
able to have column 4 be the value of (col3 * .07). I have RTFM and other
books but it seems that you are not allowed to perform calculations during
the load except the date functions.
Am I correct in my understanding?
Control file info:
Load data
Append
Into table tab1
trailing nullcols
( col1 terminated by "," ,
col2 terminated by "," "TO_DATE(:col2,'YYYYMMDD')",
col3 terminated by "," ,
col4 terminated by "," ,
col5 terminated by "," )
The source data has values in each location:
123,20010920,20,30,35
Any Ideas?
Thanks,
Ron
ROR m���m
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ron Rogers
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mercadante, Thomas F
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
