Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: SQLLOADER question.

RE: SQLLOADER question.

From: Ken Janusz <ken.janusz_at_sufsys.com>
Date: Fri, 21 Sep 2001 12:19:09 -0700
Message-ID: <F001.00395219.20010921121627@fatcity.com>

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 mm

-- 
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).
Received on Fri Sep 21 2001 - 14:19:09 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US