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: Nirmal Kumar Muthu Kumaran <NIRMALK_at_qtel.com.qa>
Date: Sun, 23 Sep 2001 01:28:14 -0700
Message-ID: <F001.00395B23.20010923011517@fatcity.com>

Hi,

You can use the same with little modification. Since if there is more no. of columns, then "terminated by" is more headache.

Load data
infile *
Append
Into table tab1
fields terminated by ','
trailing nullcols
( col1 , col2 , col3 , col4 ":col3*.07", col5) begindata

123,20010920,20,30,35
123,20010920,20,30,35
123,20010920,20,30,35

Regards,
Nirmal.

> -----Original Message-----
> From: Mercadante, Thomas F [SMTP:NDATFM_at_labor.state.ny.us]
> Sent: Friday, September 21, 2001 11:16 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: SQLLOADER question.
>
> 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).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Nirmal Kumar  Muthu Kumaran
  INET: NIRMALK_at_qtel.com.qa

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 Sun Sep 23 2001 - 03:28:14 CDT

Original text of this message

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