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-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: 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).