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: Mercadante, Thomas F <NDATFM_at_labor.state.ny.us>
Date: Fri, 21 Sep 2001 12:22:20 -0700
Message-ID: <F001.00395232.20010921121628@fatcity.com>

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 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: Mercadante, Thomas F INET: NDATFM_at_labor.state.ny.us 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:22:20 CDT

Original text of this message

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