Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: SQLLOADER question.
Get yourself a copy of Oracle SQL*Loader by Gennick & Mishra, O'Reilly Books.
I reviewed the discussion of it in Ch 8 of the book. It looks like you need to script a Function and then reference the Function name in the Control File.
Hope this helps.
It's not to simple so you need to get the book.
Ken Janusz, CPIM
Database Conversion Lead
Sufficient Systems, Inc.
-----Original Message-----
Sent: Friday, September 21, 2001 2: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: RROGERS_at_galottery.org 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: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-LReceived on Fri Sep 21 2001 - 14:19:09 CDT
(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: Ken Janusz INET: ken.janusz_at_sufsys.com 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: ListGuru_at_fatcity.com (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).